dkfr.net
当前位置:首页 >> orAClE 怎样将sElECt 语句的查询结果作为另一个sEl... >>

orAClE 怎样将sElECt 语句的查询结果作为另一个sEl...

存储过程直接打印 Create or replace procedure Sel is AA date; begin Select sysdate into AA from dual; dbms_output.put_line(AA); end; 变量返回 Create or replace procedure Sel (AA out date) is begin Select sysdate into AA from dua...

create or replace procedure sel2 as v_name varchar2(10); v_addr varchar2(20); begin select sname,addr into v_name,v_addr from stu5 where sname='张华'; dbms_output.putline(v_name||' '||v_addr); end sel2; / ----------------- begi...

create or replace procedure sel_stu(var_dep in varchar, num_sno out student.sno%type, var_sna out student.sname%type, var_sco out student.score%type, var_depid out student.department_id%type) is begin select sno, sname, score, ...

存储过程(procedure):是一个命名了的语句块,可以有0个或多个参数 语法: create or replace procedure HelloWorld as begin dbms_output.put_line('HelloWorld'); end; 调用存储过程 * 命令调用 exec helloworld * 语句块调用 begin helloworl...

网站首页 | 网站地图
All rights reserved Powered by www.dkfr.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com