oracle ´æ´¢¹ý³ÌµÄСÎÊÌâ - Oracle / ¿ª·¢

ÒÔÏÂÊǽØÈ¡oracle´æ´¢¹ý³ÌµÄÒ»¸öƬ¶Î 
tablename :='CLTX_'||cur_dt1||mm1;
  dbms_output.put_line(tablename);
   
  execute immediate 'select count(*) into '|| temp3||' from USER_TABLES where table_name='||tablename;
  dbms_output.put_line('temp3:'||temp3)
  if tem3>0 then
  dbms_output.put_line('±íÒÑ´æÔÚ');
  else
  dbms_output.put_line('±íbu´æÔÚ');
  end if;
×¢£¨tablenameΪvarchar±äÁ¿£¬temp3Ϊnumber»òÕßint±äÁ¿£©

ÉÏÃæÕâ¶Î³ÌÐòÔÚ´¥·¢Æ÷ÀïÃæ¿ÉÒÔ±àÒëͨ¹ý£¬ÎªÊ²Ã´ÔÚ´æ´¢¹ý³ÌÖÐÎÞ·¨±àÒëͨ¹ý£¬ºÜÊDz»½â£¿

ÁíÍâÒ»¸öÎÊÌâinsert into CLTX_200805_200809 select * from CLTX_200809;Ϊʲô²»ÄÜ°Ñ
CLTX_200809±íÖÐÊý¾ÝÌí¼Ó½øCLTX_200805_200809 £¿×¢£ºÁ½¸öͬ¹¹

---

¸Ä³ÉÏÂÃæµÄÓï¾äÖ´Ðп´¿´
 EXECUTE IMMEDIATE 'select count(*) from USER_TABLES where table_name= :1'
  INTO temp3
  USING tablename;

---

ÁíÒ»¸öÎÊÌâSQL code:

--±í½á¹¹¸´ÖÆ(È«²¿¸´ÖÆ)
--sqlserver select *¡¡into A from B
create table A as(select * from B)
--Ö»¸´Öƽá¹û
--sqlserver select * into A from B where 2!=1
create table A as(select * from B where 5=3)

---

EXECUTE IMMEDIATEÖеÄselect intoҪעÒâ¡£
SQL code

---

Code highlighting produced by A