Oracle SQL Tutorial -10 Data Dictionary

Hi ,

In this article I will tell you how to use data dictionary views , what is a data dictionary .

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

USER_OBJECTS

It gives us information about all objects owned by the user .

  1. Date the object was created ,

  2. Date of last modification ,

  3. Object type ,

  4. The validity of the object .

SELECT * FROM USER_OBJECTS;

blank

ALL_OBJECTS

Gives information about the objects that the user owns and can also access .

SELECT * FROM ALL_OBJECTS;

blank

  1. Tables created by users can be queried ,

SELECT * FROM USER_TABLES;

blank

  1. Columns of tables can be queried ,

SELECT * FROM USER_TAB_COLUMNS;

blank

  1. Constraints created by users can be queried ,

SELECT * FROM USER_CONTRAINTS;

blank

  1. Provides brief information about Constraintler .

SELECT * FROM USER_SEQUENCES;

blank

SELECT * FROM USER_VIEWS;

blank

See you in my next post.

 356 views last month,  2 views today

About Melike Duran

blank

Check Also

blank

Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27

Hi, I will explain Create Table ( CTAS ) and Data Types in Oracle SQL in …

Leave a Reply