In this article I will tell you how to use data dictionary views , what is a data dictionary .
Database information is information about all objects , user privileges , and locations where the information is stored . They can be obtained from tables or views .
HOW TO USE DATA DICTIONARY VIEWS ?
All view names we want to search are under DICTIONARY .
It has only 2 columns named Table_name and comments .
SELECT * FROM DICTIONARY;
DATA DICTIONARY VIEWS
It gives us information about all objects owned by the user .
Date the object was created ,
Date of last modification ,
Object type ,
The validity of the object .
SELECT * FROM USER_OBJECTS;
Gives information about the objects that the user owns and can also access .
SELECT * FROM ALL_OBJECTS;
Tables created by users can be queried ,
SELECT * FROM USER_TABLES;
Columns of tables can be queried ,
SELECT * FROM USER_TAB_COLUMNS;
Constraints created by users can be queried ,
SELECT * FROM USER_CONTRAINTS;
Provides brief information about Constraintler .
SELECT * FROM USER_SEQUENCES;
SELECT * FROM USER_VIEWS;
See you in my next post.
356 views last month, 2 views today