Exercise (Data Dictionary I)

1. Select table names created by SCOTT.
2. Select view names created by SCOTT.
3. Select trigger names on EMP table.
4. Display all indexes on DEPT table.
5. Display all the user names from oracle database.
6. Select table owner, names created by SCOTT or JHON
7. Select all the sequences created by current user.
8. Display trigger’s text for ‘EMP_INSERT_TR’ trigger.
9. Display all the data dictionary objects which starts with ‘USER’.
10. Display all the roles available in the database.