![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PL/SQL
落落叶叶无声
做过后端,现在主前端的开发工程师...
展开
-
PL/SQL 动态SQL
EXECUTE IMMEDIATE sqlstr语句规则若sqlstr是一个普通的select,则使用 EXECUTE IMMEDIATE sqlstr INTO v USING v1, v2... 或者 EXECUTE IMMEDIATE sqlstr BULK COLLECT INTO v USING v1, v2... 若sqlstr是一个匿名的plsql语句,则使用 EXECUTE原创 2017-03-29 17:02:24 · 544 阅读 · 0 评论 -
Oracle Collection 集合
-- Associative Array Indexed by String DECLARE TYPE ASS_ARR1 IS TABLE OF NUMBER INDEX BY VARCHAR2(64); ASS_ARR ASS_ARR1; I VARCHAR2(63);BEGIN ASS_ARR('a') := 1; ASS_ARR('b') := 2; ASS_AR原创 2017-03-10 15:58:15 · 7514 阅读 · 0 评论 -
PL/SQL 批量插入
批量插入 CREATE TABLE t(a INT CHECK(a < 3)); DECLARE TYPE t_list IS TABLE OF NUMBER(2); t_list_1 t_list := t_list(1,4,2,5,34,34,1,0,-1); BEGIN FORALL i IN 1..t_list_1.count SAVE EXCEPTIONS INS原创 2017-03-30 20:34:53 · 1532 阅读 · 0 评论 -
PL/SQL 动态Sql拼接where条件
DECLARE SQLSTR VARCHAR(200) := 'SELECT * FROM hr.employees where 1=1'; TYPE EMPCURTYP IS REF CURSOR; V_EMP_CURSOR EMPCURTYP; EMP_RECORD HR.EMPLOYEES%ROWTYPE; TYPE EMP_REC IS T原创 2017-03-15 14:57:13 · 9250 阅读 · 0 评论