查詢所有表名:
select t.table_name from user_tables t;
查詢所有字段名:
select t.column_name from user_col_comments t;
查詢指定表的所有字段名:
select t.column_name from user_col_comments t where t.table_name = 'BIZ_DICT_XB';
查詢指定表的所有字段名和字段說明:
select t.column_name, t.column_name from user_col_comments t where t.table_name = 'BIZ_DICT_XB';
查詢所有表的表名和表說明:
select t.table_name,f.comments from user_tables t inner join user_tab_comments f on t.table_name = f.table_name;
查詢模糊表名的表名和表說明:
select t.table_name from user_tables t where t.table_name like 'BIZ_DICT%';
select t.table_name,f.comments from user_tables t inner join user_tab_comments f on t.table_name = f.table_name where t.table_name like 'BIZ_DICT%';
--查詢表的資料條數、表名、表注釋
select a.num_rows, a.TABLE_NAME, b.COMMENTS
from user_tables a, user_tab_comments b
WHERE a.TABLE_NAME = b.TABLE_NAME
order by TABLE_NAME;
轉載自:https://www.cnblogs.com/hyq0002013/p/5948419.html
oracle 查詢一張表或者視圖的建表/視圖語句:
select dbms_metadata.get_ddl('類型','名稱') from dual ;
類型:view ,table
名稱:寫表/視圖名字
轉載自:https://blog.csdn.net/xiaowen_1990/article/details/79268355
oracle 查詢目前使用者下的表名 + 表注釋
select t.table_name tableName, f.comments comments
from user_tables t
inner join user_tab_comments f
on t.table_name = f.table_name
oracle 查詢某表的所有字段 + 字段注釋 + 字段類型
SELECT t.TABLE_NAME tableName,
t.COLUMN_NAME columnName,
t.DATA_TYPE dataType,
a.COMMENTS
FROM USER_TAB_COLUMNS t
LEFT JOIN USER_COL_COMMENTS a
ON t.table_name = a.table_NAME
AND t.COLUMN_NAME = a.COLUMN_NAME
轉載自:https://www.cnblogs.com/yuxiaole/p/9786206.html