第一步：新建存储过程 CREATE PROCEDURE PCreateDeleteTrigger @tableName varchar(128) AS DECLARE @fields sysname,@sqlStr VARCHAR(2048),@log_tableName varchar(128) SET @log_tableName = @tableName+'_DeleteLog' SET @sqlStr = '' SET @sqlStr ='select top 0 * into '+@
代码如下:select line,text from dba_source where name=’PRO_E_F_ORDER_STAT’; select object_name,object_type from dba_objects where object_type=’PROCEDURE’;
您可能感兴趣的文章:Oracle存储过程游标用法分析oracle存储过程常用的技巧（详）asp.net中调用oracle存储过程的方法C#调用Oracl
