17,086
社区成员
发帖
与我相关
我的任务
分享
begin
execute immediate 'select * from dual';
end;
set serveroutput on;
declare v_name varchar2(30);
begin
--当输出只是一条记录时用into,多条记录时用游标
select table_name into v_name from user_tables where table_name='EMP';
dbms_output.put_line(v_name);
end;
declare l_char varchar2(20);
2 begin
3 select * into l_char from dual;
4 dbms_output.put_line(l_char);
5 end;
6 /
declare
text dual.dummy%type;
begin
select * into text from dual;
end;
第二句是PL/SQL 输出的方式不一样!