Exercise ( Data DictionaryII)

1. Display synonyms created by SCOTT.
2. Display all the constraints defined for employee table.
3. Display all the check constraints defined for employee table.
4. Display procedure text for ‘SP_INSERTEMP’.
5. Display all procedures available in the database.
6. Display all the functions created by SCOTT.
7. Display function text for ‘FN_CHECKEMP’.
8. Display Sequences created by SCOTT.
9. Display different Tablespaces available in the database.
10. Display tables in 'USER_DATA' tablespace.