1, Get table :
select table_name from user_tables; // Tables owned by the current user select table_name from
all_tables; // Tables for all users select table_name from dba_tables; // Include system table select
table_name from dba_tables where owner=' user name ' ALL_OBJECTS describes all objects
accessible to the current user. Describes all objects that the current user has access to DBA_OBJECTS describes all
objects in the database. Describes all objects in the database USER_OBJECTS describes all objects owned
by the current user. Describes all objects owned by the current user
* user_tables:TABLE_NAME,TABLESPACE_NAME,LAST_ANALYZED etc.
* dba_tables:ower,table_name,tablespace_name,last_analyzed etc.
* all_tables:ower,table_name,tablespace_name,last_analyzed etc.
* all_objects:
ower,object_name,subobject_name,object_id,created,last_ddl_time,timestamp,status etc.
2, Get table fields :
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 ';
3, Get table comments :
user_tab_comments; Table notes select * from user_tab_comments
user_tab_comments:table_name,table_type,comments
There is a corresponding dba_tab_comments,all_tab_comments, These two ratios user_tab_comments More ower column .

4, Get field comment :
select * from user_col_comments
user_col_comments:table_name,column_name,comments
There is a corresponding dba_col_comments,all_col_comments, These two ratios user_col_comments More ower column .

user_col_comments; Table field comment ( Column comment )
USER_COL_COMMENTS The view displays the comments that have been entered for the columns in the table . These comments are passed through the comment Command is added to the database .USER_COL_COMMENTS
Include views 3 column :

* Table_Name Table or view name
* Column_Name Listing
* Comments Comments already entered for this column
 

Technology
©2019-2020 Toolsou All rights reserved,
Online troubleshooting HTTP Status code ——415 and 406 Digital rolling lottery program Hackbar Using the tutorial SSM Project's excel File upload and add to database ( Essence )2020 year 7 month 12 day webpack Use of common plug-ins Redis Counter High concurrency applications JAVA Convert a string to a numeric type Output string at specified position --PTAHack Bar 2.1.2 Press F9 No response ToastUtils Use of