--查询表的列数,owner为用户名,table_name表名,二者均为大写 select count(*) from dba_tab_columns where owner='DFZC_DEV' and table_name='REPAYING_PLAN_HISTORY'