ORACLE JAVA开发
-
编辑 删除
存储过程中返回游标类型的处理
create or replace procedure mycur(o out sys_refcursor)as begin open o for select * from node; end;如何在Sql·plus中调试？ SQL>set autoprint on;SQL>var o REFCURSOR;SQL>exec mycur(:o);--注意使...
-
编辑 删除
oracle10.2.0.1上not in的一个小问题
create table AL( NODE_ID VARCHAR2(128) not null, PROPERTY_ID VARCHAR2(128) not null, VALUE NUMBER not null, VINDEX&n...
-
编辑 删除
start with connect by prior 的2种写法
select * from node_definition start with super_id ='Q2' connect by super_id = prior pkidselect * from node_definition start with super_id ='Q2' connect by prior pkid = super_id这2...
