DELPHI 如何在 oracle CREATE一個temp table

ORACLE的TEMPTABLE必須先開好在ORACLE中，DELPHI使用時再呼叫TEMPTABLE來使用。

如果你是用query的話,建議用qurey搭配cacheupdate去作暫存的功能,這樣會比較好一點喔! Pillar Wang

------
Pillar Wang

例如

Create global temporary table T1 
                    (
                     id number(10)
                     ) on commit preserve rows

用query1.execsql執行即可create temp table. 參考http://www.devx.com/tips/Tip/14189 用完記得要drop table。 星期一,星期二...星期日..星期一..無窮迴圈@@

------
星期一,二...無窮迴圈＠＠

ORACLE的暫存資料表格都須以 Create global temporary table tempTable ( id number, value number ) on commit delete rows; 類似語法產生?? 有無像SQL-SERVER中可直接 Select * Into #Table From Table . 發表人 - pcjung 於 2005/01/07 23:06:49

------
--Written by max

要像SQL server那樣，轉個彎就ok了 例如

Create global temporary table T1 on commit delete rows 
as select * from Table

星期一,星期二...星期日..星期一..無窮迴圈@@

------
星期一,二...無窮迴圈＠＠

工作上用到的，讓你參考參考

declare
x varchar2(30);
begin
  select 'SCATTER' || '_' || TO_CHAR(serial#) || '_' || TO_CHAR(userenv('sessionid')) into x from v$session
  where audsid = userenv('sessionid');
  execute immediate 'Create view ' || x || ' as 
    select t2.* from
    (
    select rownum r, t.* from 
    (
    select vd.* from var_measuredetail_2848 vd
    where vd.ctrlid in (3,2,1) and 
    vd.groupid in (select groupid from var_measuremaster_2848 vm 
    where vm.ctrlid in (3,2,1) and vm.ifvalid <>''0'') 
    and 1=1
    and vd.ifvalid <> ''0''
    intersect
    select vd.* from var_measuredetail_2848 vd
    where vd.ctrlid in (3,2,1) and 
    vd.groupid in (select groupid from var_measuremaster_2848 vm 
    where vm.ctrlid in (3,2,1)
    and vm.ifvalid <>''0'') 
    and 1=1
    and vd.ifvalid <> ''0''
    ) t
    ) t2
  ';
end;