SELECT column_name from (
select a.column_name,row_number() over (order by column_id ) rn
from user_tab_cols a where table_name=upper('tablename'))
WHERE rn=3
select a.column_name,row_number() over (order by column_id ) rn
from user_tab_cols a where table_name=upper('tablename'))
WHERE rn=3
user_tab_columns 中 COLUMN_ID 字段用来表示字段的位置select column_name from user_tab_columns where table_name='T' and COLUMN_ID=3;如果要根据查询结果,进而得出该列的内容,建议上 baidu 搜搜 DBMS_SQL 的用法
或
select column_name from user_col_comments
where table_name='T' and rownum<=3;
都可以求出前3列的列名,可是换成=3,只取第三列却取不出,有谁知道?