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;
