![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
pl/sql
文章平均质量分 72
diqye2011
这个作者很懒,什么都没留下…
展开
-
JDBC调用存储过程输出游标参数的存储过程
--oracle存储过程代码create or replace procedure out_cursor(res out sys_refcursor , in_para in number) isbegin open res for select * from c where c.c = in_para;end out_cursor;/ --Java原创 2012-01-08 15:21:17 · 2044 阅读 · 1 评论 -
pl/sql demo
=================================================基本操作=================================================SQL>set serveroutput on; --显示输出---------------------------------------------------L转载 2011-12-21 10:20:41 · 320 阅读 · 0 评论 -
PL/SQL積累
--1.UNION ALL SELECT SUM(one) ,two FROM (SELECT 1 one, 3 two FROM dual UNION ALL SELECT 3, 5 FROM dual UNION ALL SELECT 4, 3 FROM dual)GROUP BY two--2,插入記錄INSERT INTO table_n原创 2012-03-02 11:38:22 · 750 阅读 · 0 评论 -
plsql 类似Java中的split方法 字符串分割
--包头CREATE OR REPLACE PACKAGE asset_formation_api IS -- Author : DIQYE -- Created : 2012/11/8 10:40:38 -- Purpose : dd TYPE check_bill_id_table IS TABLE OF VARCHAR2(30) INDEX BY BINARY_原创 2012-11-08 15:14:18 · 4612 阅读 · 0 评论