-- user_tab_columns 自定義的字段
SELECT column_name FROM user_tab_columns where table_name = upper('表名')?
-- user_tab_cols 包含oracle創(chuàng)建的隱藏字段
SELECT column_name FROM user_tab_cols where table_name = upper('表名')?

select Listagg(column_name, ',') WITHIN GROUP(ORDER BY column_name)
from user_tab_columns?
where table_name = upper('表名')?
--不想查詢的字段名
and column_name not in ('字段名','字段名');

select table_name from user_tables; //當(dāng)前用戶擁有的表
select table_name from all_tables; //所有用戶的表
select table_name from dba_tables; //包括系統(tǒng)表
select table_name from dba_tables where owner='用戶名'
ALL_OBJECTS      describes all objects accessible to the current user.    描述當(dāng)前用戶有訪問權(quán)限的所有對象 
DBA_OBJECTS     describes all objects in the database.                            描述了數(shù)據(jù)庫中的所有對象 
USER_OBJECTS    describes all objects owned by the current user.        描述了當(dāng)前用戶所擁有的所有對象 

user_tab_comments;表注釋
select * from user_tab_comments
user_tab_comments：table_name,table_type,comments

user_tab_comments;表注釋
select * from user_tab_comments
user_tab_comments：table_name,table_type,comments

select * from user_col_comments
user_col_comments：table_name,column_name,comments

select table_name,column_name,comments from user_col_comments where table_name=‘JH';