SELECT COLUMN_NAME,DATA_TYPE,DATA_LENGTH //字段名稱,數據類型,長度 FROM (SELECT to_char(rownum) num ,COLUMN_NAME,DATA_TYPE,DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE table_name = 'BUILDING') where num = 2 NOTE:表名字母要大寫
select colno,cname,coltype,width from col where tname=table_name
dba_tab_columns
all_tab_columns
dba_tab_columns
all_tab_columns
就是这些了
FROM
(SELECT to_char(rownum) num ,COLUMN_NAME,DATA_TYPE,DATA_LENGTH
FROM ALL_TAB_COLUMNS
WHERE table_name = 'BUILDING')
where num = 2
NOTE:表名字母要大寫
from col
where tname=table_name