[Oracle]oracle查询表列名、及列数

--查询表列数
select count( column_name )
from user_tab_columns
where table_name = 'CJ_HOME_MEDICAL_RECORD'; --表名为大写

--查询表列名
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'CJ_HOME_MEDICAL_RECORD' ORDER BY COLUMN_ID; --表名为大写