Oracle Global Temporary Table Example
They are special kind of tables in Oracle which have structure and definition same as other usual Oracle tables but where data is not persistent.
Data is only session specific or transaction specific. This means that users can insert data into the table simultaneously but they will never see each others data.
Syntax:
CREATE GLOBAL TEMPORARY TABLE SCHEMA_NAME.TABLE_NAME
(
COL1 DATATYPE,
COL2 DATATYPE,
.
.
.
COLNn DATATYPE
)
ON COMMIT DELETE ROWS
NOCACHE;
There are two options available for ON COMMIT clause
Recent Comments