代码改变世界

随笔分类 -  21.Oracle

ORACLE: SELECT语句里调用函数使用DML语句进行Update/Insert/Delete操作

2010-08-14 10:35 by Jun2009, 857 阅读, 收藏,
摘要： FUNCTION get_tg_dop_reserved( dop_id_ IN NUMBER) RETURN VARCHAR2IS PRAGMA AUTONOMOUS_TRANSACTION; /* 注意：这句话必须写*/ dummy_ NUMBER; CURSOR c1 IS SELECT 1 FROM DOP_HEAD a WHERE a.dop_id = dop_id_ AND a.ob... 阅读全文
跟小D每日学口语