OracleÇóÒ»¼òµ¥¹ý³Ì

Ò»¸ö¹ý³Ì´ø²ÎÊý£¬´«¹ýÀ´µÄ²ÎÊýÊDzéѯ±íÃûµÄÒ»²¿·Ö£¬ÎÒ²»ÖªµÀ±äÁ¿ºÍ×Ö·û´®Ôõô½ÓºÏ

---

¾ÙÀýÈçÏ£º
SQL code:
declare
v_sql varchar2(200);
v_table_name varchar2(20) :='test';
begin
v_sql:=[color=#FF0000]'select * from '||v_table_name||''[/color];
execute immediate v_sql;
dbms_output.put_line(v_sql);
end;

---

declare
v_sql varchar2(200);
v_table_name varchar2(20) :='test';
begin
v_sql:='select * from '||v_table_name||'';
execute immediate v_sql;
dbms_output.put_line(v_sql);
end;

---

||

---

v_sql := 'select * from '||v_tablename;
execute immediate v_sql;

---

×Ö·û´®Á¬½ÓÓÃ||
¶¯Ì¬sqlÖ´ÐÐÓà execute immediate
Èç¹ûÊÇselect£¬Ö±½Ó¶¨ÒåÒ»¸öv_sql  varchar2(1000);
È»ºóopen Óαê for v_sql¼´¿É

---

ÒýÓÃ

¾ÙÀýÈçÏ£º
SQL codedeclare
v_sqlvarchar2(200);
v_table_namevarchar2(20) :='test';begin
v_sql:='select * from'||v_table_name||'';execute immediate v_sql;
dbms_output.put_line(v_sql);end;

...