Write SQL statements to do the following:

Question

(1) List the name and granted roles of the current user;
(2) List name and type of all objects owned by the current user;
(3) List table name and the tablespace name to which the table is assigned of all
tables owned by the current user;
(4) List the next value of the sequence Emp_Seq.

Answer 1

(1) SELECT USERNAME, GRANTED_ROLE
FROM USER_ROLE_PRIVS;
(2) SELECT OBJECT_NAME, OBJECT_TYPE
FROM USER_OBJECTS;
(3) SELECT TABLE_NAME, TABLSPACE_NAME
FROM USER_TABLES;
(4) SELECT Emp_Seq.NEXTVAL
FROM SYS.DUAL;