[Oracle]一時表(global temporary table)のサンプル
1.セッション終了、データを削除
create global temporary table user_tbl(
column1 number,
column2 number
)
on commit preserve rows
create global temporary table user_tbl(
column1 number,
column2 number
)
on commit preserve rows
create global temporary table user_tbl( column1 number, column2 number ) on commit preserve rows
2.トランザクション終了、データを削除
create global temporary table user_tbl(
column1 number,
column2 number
)
on commit delete rows
create global temporary table user_tbl(
column1 number,
column2 number
)
on commit delete rows
create global temporary table user_tbl( column1 number, column2 number ) on commit delete rows