oracle中查看表字段数据类型及存储过程语句

select column_name as 字段名, data_type as 数据类型, DATA_LENGTH as 数据长度 from user_tab_columns where table_name = 'CON_AUDITBOOKINFO' and column_name in ('BOOKNAME','PENNAME')


看存储过程的文本:
select text from all_source where OWNER= 'USERNAME '
and TYPE= 'PROCEDURE ' and NAME= 'PROCNAME '