Interview Tips Interview Tips, Interview Questions and Answers

24Mar/100

Data Dictionary Queries for Oracle

For ORACLE
select * from sys.dba_objectswhere owner = 'scott'and object_type='TABLE'
SELECT owner, object_name, object_type FROM sys.dba_objectswhere object_type='SEQUENCE' and owner='scott';