oracle
bianxiaolong
我就是我
展开
-
dblink
create public database link ### connect to TEST identified by TEST using'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))';原创 2021-08-25 11:49:42 · 123 阅读 · 0 评论 -
简单存储过程实例
//创建 create or replace procedure p_subwork(put number,s out varchar2) is r subwork%rowtype; BEGIN dbms_output.put_line('subunit username'); select * into r from subwork where subwor...原创 2011-05-27 10:04:05 · 212 阅读 · 0 评论 -
学游标
//显示游标 loop declare cursor cur_stu is select* from student; c_ cur_stu%rowtype; BEGIN if cur_stu%isopen then CLOSE cur_stu; end if ; open...原创 2011-05-27 13:23:20 · 90 阅读 · 0 评论