oracle存储过程的基本用法

1.赋值
  t_name := 'aaaaa';
  t_age := 10;
2.创建一个存储过程
    CREATE OR REPLACE PROCEDURE  pTest (p_name IN varchar2,p_age IN number)
    IS
    v_name varchar2;
    v_age number;
   BEGIN
   --业务逻辑
   END pTest 
3.oracle 的数据类型
   varchar2,number
4.SELECT INTO STATEMENT
   BEGIN
       select col1,col2 into v1,v2 from emp_zz a where a.empno = 12
       EXCEPTION 
            WHEN NO_DATA_FOUND THEN 
             xxx;
   END;
5.IF 判断
   IF v_test = 1 THEN 
   BEGIN 
       --业务逻辑
   END 
  END IF
6.while 循环
  WHILE v_test = 1 LOOP 
       BEGIN 
              --业务逻辑