/*
create table EMPLOYEE
(
employee_number NUMBER,
employee_name VARCHAR2(30),
salary NUMBER(7,2),
department_id NUMBER
)
*/
declare
type employee_t is record(
employee_number employee.employee_number%type,
employee_name employee.employee_name%type,
salary employee.salary%type,
department_id employee.department_id%type);
employee_rec employee_t;
begin
select em.employee_number, em.employee_name, em.salary, em.department_id
into employee_rec
from employee em
where rownum = 1;
dbms_output.put_line(employee_rec.employee_number);
dbms_output.put_line(employee_rec.employee_name);
dbms_output.put_line(employee_rec.salary);
insert into employee values employee_rec;
end;
PLSQL总结——14.记录
最新推荐文章于 2024-07-02 21:00:00 发布