ORACLE常用语法
--定义一个对象类型的变量CREATE OR REPLACE PROCEDURE TEST_1 ISTYPE N_OBJECT IS RECORD( n_no number, v_namevarchar2(20), v_phone varchar2(20));n_o N_OBJECT;BEGINn_o.n_no := 10;n_o.v_name:= 'jack';n_o.v_phone := '15910906597';dbms_output.put_line(n_o.n_no || ',' || n_o.v_name || ',' || n_o.v_phone);END;--LOOP循环用法CREATE OR REPLACE PROCEDURE TEST_2 ISn_number number:=1;BEGINLOOP dbms_output.put_line(n_number); n_number := n_number + 1; EXIT WHEN n_number = 10;END LOOP;END;--FOR循环用法CREATE OR REPLACE PROCEDURE TEST_3 ISBEGINFOR n_f IN 1..10 LOOPDBMS_OUTPUT.put_line(n_f);END LOOP;END;--游标用法CREATE OR REPLACE PROCEDURE TEST_4 ISCURSOR c_cur is SELECT DNAME FROM DEPT;v_dname varchar2(100);BEGINOPEN c_cur;LOOP FETCH c_cur into v_dname; DBMS_OUTPUT.put_line(v_dname); EXIT WHEN c_cur%NOTFOUND;END LOOP;CLOSE c_cur;END;
页:
[1]