随笔分类 -  SQL

摘要:declare cursor proce is Select Object_Name,owner,object_type From All_Objects Where Status = 'INVANID' and (Object_type = 'PROCEDURE' or lower(Object_type) = 'function'); Strsql Varchar2(200); BE... 阅读全文
posted @ 2017-12-13 00:07 雅虎跳跳 阅读(389) 评论(0) 推荐(0)
摘要:declare hitoryid number; flow_id number; item_result_new_id number; node_item_result_id number; common_diag_seq varchar2(64); new_diag_seq varchar2(64); k number; indi... 阅读全文
posted @ 2017-12-13 00:06 雅虎跳跳 阅读(1516) 评论(0) 推荐(0)