Background Using Temporary Table Outline Temporary Table Create Temporary Table Option:- On Commit On Commit Preserve Rows On Commit Delete Rows  Discard all existing Data Truncate Table Insert Data Insert Data using "insert into" Fetch Data Fetch Data using "select" Truncate Data Truncate data from temporary table using "truncate table" Drop Table Drop Table Using … Continue reading Oracle – Temporary Table – Drop Table