摘要:
SELECT * FROM ALL_SOURCE WHERE UPPER(TEXT) LIKE UPPER('%insert into AA_yu_pay_detail%') and owner='AA_USER'; 阅读全文
posted @ 2024-09-25 17:53
滑溜溜的小热浪
阅读(360)
评论(0)
推荐(0)
摘要:
select b.table_name,b.comments tableComments,c.column_name,c.comments columnCommentsfrom user_tab_comments b,user_col_comments cwhere b.table_name=c.t 阅读全文
posted @ 2024-09-25 17:49
滑溜溜的小热浪
阅读(37)
评论(0)
推荐(0)
摘要:
示例文本: select UPPER('up_up') as u from dual; 结果: UP_UP 阅读全文
posted @ 2024-09-25 17:47
滑溜溜的小热浪
阅读(20)
评论(0)
推荐(0)
摘要:
示例脚本: begin --执行需要处理的存储过程 syn_A_from_B_extend(I_erpNo,n_id,I_UserId,I_UserName,O_ReState,O_ReString) ; exception when others then null;--暂时不记录这个异常,也可以 阅读全文
posted @ 2024-09-25 17:43
滑溜溜的小热浪
阅读(10)
评论(0)
推荐(0)