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 '