Oracle SQL Magical + table annotations

select table_name from user_tables; //tables owned by the current user         select table_name from all_tables; //table for all users  SELECT TABLE_NAME FROM DBA _tables; //includes system table select table_name from dba_tables where owner= ' user name '  user_ Tables:table_name,tablespace_name,last_analyzed et dba_tables:ower,table_name,tablespace_name,last_analyzed et All_ Tables:ower,table_name,tablespace_name,last_analyzed and other all_objects:ower,object_name,subobject_name,object_id, Created,last_ddl_time,timestamp,status et Select * from user_tab_columns where table_ Name= ' user table '; select * from all_tab_columns where table_name= ' user table ';select *  From dba_tab_columns where table_name= ' user table '; User_tab_columns:table_name,column_name,data_type, DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE,COLUMN_ID and other All_tab_columns :ower,table_name,column_name, Data_type,data_length,data_Precision,data_scale,nullable,column_id et Dba_tab_columns:ower,table_name,column_name,data_type,data_length,data _precision,data_scale,nullable,column_id et select * from user_tab_commentsuser_tab_comments:table _name,table_type,comments corresponding to the dba_tab_comments,all_tab_comments, these two more than User_tab_comments ower column. Get field Comment: select * from user_col_commentsuser_col_comments:table_name,column_name,comments the corresponding DBA _col_comments,all_col_comments, these two are more than user_col_comments ower column.

Oracle SQL Magical + table annotations