Oracle - How to use DICTIONARY|| user tables || user table's columns || user table's constraints
-- DICTIONARY. It contains the names and descriptions of the dictionary tables and views
-- It contains the table names and comments
select *
from dictionary;
select *
from dictionary
where table_name='USER_OBJECTS';
--Query User objects to see all the objects that you own
select *
from USER_OBJECTS;
--precisely
select OBJECT_NAME,OBJECT_TYPE,CREATED,STATUS
from USER_OBJECTS
ORDER BY OBJECT_NAME;
--table information
DESCRIBE user_tables;
--for table name
SELECT table_name
FROM user_tables;
SELECT table_name
FROM tabs;
--Column Information
DESCRIBE user_tab_columns
SELECT *--column_name, data_type, data_length,data_precision, data_scale, nullable
FROM user_tab_columns
WHERE table_name = 'EMPLOYEES';
--Constraint Information
DESCRIBE user_constraints
SELECT constraint_name, constraint_type,
search_condition, r_constraint_name,
delete_rule, status
FROM user_constraints
WHERE table_name = 'EMPLOYEES';
--Querying USER_CONS_COLUMNS
DESCRIBE user_cons_columns
SELECT constraint_name, column_name
FROM user_cons_columns
WHERE table_name = 'EMPLOYEES';
@rejawebs @Oracle @OracleLearning @redbullracing @CelineOracle @OracleLearning @OracleBhaiya @JzOracleChannel @viraloracle5151
Searchable Keywords:
data dictionary | Oracle SQL | data dictionary in sql | Oracle dictionary
Oracle Tutorial | Oracle SQL Data Dictionary
Data Dictionary View In Oracle | Learn simply with me
Data Dictionary in Oracle | Oracle SQL Tutorial Videos
Oracle DB - Dynamic Performance View & Data Dictionary
Oracle - How to use DICTIONARY|| user tables || user table's columns || user table's constraints
Data Dictionary in Oracle, System Tables
Oracle Interview Question and Answers, User Tables VS Data Dictionary
Oracle PL/SQL Tutorials | Triggers in Oracle
ORACLE DATA DICTIONARY INTRODUCTION
Importing a Data Dictionary to a Model using Oracle SQL Developer Data Modeler
Data Dictionary in Oracle | Oracle SQL Tutorial Videos
How to generate Oracle data dictionary from SQL script
Data Dictionary View In Oracle | Learn simply with me
What is the use of data dictionary in Oracle?
How to get data dictionary in Oracle?
What is a dictionary in Oracle?
How to read data dictionary?
How to use dictionary in oracle pdf
list of data dictionary tables in oracle
data dictionary in oracle example
oracle dictionary tables
oracle data dictionary table columns
data dictionary cache in oracle
uses of data dictionary in oracle
data dictionary | Oracle SQL
Data Dictionary in Oracle
Introduction to the Oracle data dictionary
How to generate Oracle data dictionary from SQL script
Data Dictionary View In Oracle | Learn simply with me
Oracle Tutorial | Oracle SQL Data Dictionary
Importing a Data Dictionary to a Model using Oracle SQL
How to Generate Data Dictionary Document
Oracle Data Dictionary
How to Generate Data Dictionary Document | DB Document in SQL Developer | Oracle SQL Developer Tips
What is Oracle Metadata? | Data Dictionary Views & Dynamic Performance Views
Oracle SQL Data Dictionary Views
Oracle SQL What is Data Dictionary Views
Oracle SQL beginner tutorials With exercise
ORACLE DATA DICTIONARY INTRODUCTION
Hash Tags:
#plsq #oracledatabasetutorial #oracletutorial #oraclereading #oraclecards #orcales #oracle installation
#data_dictionary
#oracle_sql
#data_dictionary_in_sql
#oracle_dictionary
#oracle_sql_data_dictionary
#data_dictionary_view_in_oracle
#data_dictionary_in_oracle
#dynamic_performance_view_&_data_dictionary
#oracle_-_how_to_use_dictionary
#data_dictionary_in_oracle
#user_tables_vs_data_dictionary
#oracle_data_dictionary_introduction
#data_dictionary_in_oracle
#data_dictionary_view_in_oracle
#what_is_a_dictionary_in_oracle?
#how_to_read_data_dictionary?
#data_dictionary_in_oracle_example
#oracle_dictionary_tables
#oracle_data_dictionary_table_columns
#data_dictionary_cache_in_oracle
#uses_of_data_dictionary_in_oracle
#data_dictionary_|_oracle_sql
#data_dictionary_in_oracle
#introduction_to_the_oracle_data_dictionary
#how_to_generate_oracle_data_dictionary_from_sql_script
#data_dictionary_view_in_oracle_|_learn_simply_with_me
#oracle_tutorial_|_oracle_sql_data_dictionary
#importing_a_data_dictionary_to_a_model_using_oracle_sql
#how_to_generate_data_dictionary_document
#oracle_data_dictionary
#how_to_generate_data_dictionary_document_|_db_document_in_sql_developer_|_oracle_sql_developer_tips
#what_is_oracle_metadata?_|_data_dictionary_views_&_dynamic_performance_views
#oracle_sql_data_dictionary_views
#oracle_sql_what_is_data_dictionary_views
#oracle_sql_beginner_tutorials_with_exercise
#oracle_data_dictionary_introduction
How to use DICTIONARY in Oracle
Oracle DICTIONARY,
Oracle Data Dictionary Structure,
Oracle How to Use the Dictionary Views,
Oracle USER_OBJECTS,
Oracle ALL_OBJECTS,
How to see user tables,
How to see user table's columns,
How to see user table's constraints,