17,090
社区成员
发帖
与我相关
我的任务
分享
tab table%ROWTYPE
SELECT * INTO TAB FROM TABLE
--只查询一条记录
declare
emp_rows emp%rowtype; -- 定义表的行类型
begin
select * into emp_rows from emp where empno = 7788; -- 必须保证记录数只有一条
dbms_output.put_line(emp_rows.empno || ',' || to_char(emp_rows.ename));
end;
--多条记录
declare
emp_rows emp%rowtype; -- 定义表的行类型
cursor cur is select * from emp;
begin
open cur;
loop
fetch cur into emp_rows;
exit when cur%notfound;
dbms_output.put_line(emp_rows.empno || ',' || to_char(emp_rows.ename));
end loop;
close cur;
end;
declare
emp_rows emp%rowtype; -- 定义表的行类型
begin
select * into emp_rows from emp where empno = 7788; -- 必须保证记录数只有一条
dbms_output.put_line(emp_rows.empno || ',' || to_char(emp_rows.ename));
end;
SQL> create table new_emp as select * from emp;
Table created
SQL>
---在sql server可以这样写
select * into new_table from table;
----在oracle中只能定义变量new_table
select * into new_table from table