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 '
我的异常网推荐解决方案：oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html
