oracle 获取表列名

 

select COLUMN_NAME
from user_tab_columns
where Table_Name = 'TABLE_NAME'
order by column_name;

注表名需大写；