Temporary Table in Oracle
Temporary Table in Oracle
Temporary Table in Oracle
Temporary table is the table exists in memory for the duration of session or transaction as declared. Data in temporary table is private to the session
You can create temporary table as 1. Global temporary table 2. Private temporary table
Difference between Global And Private temporary table 1. Global name same as permanent table V/S Private table have prefix “ORA$PTT_”.
View On WordPress












