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;