declare
table_name varchar2(4) ;
lv_date varchar2(20);
begin
table_name := 'dual' ;
select to_char(sysdate) into lv_date from table_name;
dbms_output.put_line(lv_date);
end ;
table_name varchar2(4) ;
lv_date varchar2(20);
begin
table_name := 'dual' ;
select to_char(sysdate) into lv_date from table_name;
dbms_output.put_line(lv_date);
end ;
declare
table_name varchar2(4) ;
lv_date varchar2(20);
begin
table_name := 'dual' ;
execute immediate 'select to_char(sysdate) from ' || table_name into lv_date ;
dbms_output.put_line(lv_date);
end ;
要sqlstr:='select to_char(sysdate) into lv_date from '||table_name;
execute immediate sqlstr;
declare
table_name varchar2(4) ;
lv_date varchar2(20);
begin
table_name := 'dual' ;
execute immediate 'select to_char(sysdate) from ' || table_name into lv_date ;
dbms_output.put_line(lv_date);
end ; PL/SQL block, executed in 0 sec.
2010.11.15 12:27:56
Total execution time 0.016 sec.