oracle 获取表列名

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

注表名需大写;

原文地址:https://www.cnblogs.com/Apeak/p/14733947.html