plsql_2

plsql 类型匹配

   表的列名 与变量名 都相同

    1：create or procedure xx_info(xx_name in varchar2 ) as

       where xx_name = xx_info.xx_name;

   2:使用标签

二

delcare

    first employess .fist_name%type


把结果返回plsql

    declare
     
         cursor emp_cur is

         select *

           from  employees
       where emplyee_id = &emp_id;
   emp_rec  employees % rowtype;

    begin
      open emp_cur

   fetch emp_cur into emp_rec;

      if emp_cur%found then
      dbms_output_put_line
  else
   end if;


close empr_cur

exception

  when no_data_found then
  dbms_output_put_line

end;

自定义记录结果

  declare type emp_info is record( first employees.first_name%type)

         emp_info_rec emp_info

使用游标类似


数据库返回多行处理

  set serveroutput on
    begin
   
    for emp in
        (
           select firs_name,last_name,emial
from employees

  where commisson_pct is  not null)
  Loop
   dbms

end Loop;
end;

2 游标
    set serveroutput on
      declare cursor emp_cur is
           select first_name ,last_name,emial
         
              from employees
              where .....;

emp_rec  emp_cur%rowtype;

begin
   for emp_rec in emp_cur  Loop
        dbms_output.put.line.....

       end loop;
end;