Database Reference
In-Depth Information
Figure 18.9
Add Some Rows
into the Same
Temporary Table in
a Second Session.
When selecting rows in the first session, the select statement retrieves
only rows created in the first session. Conversely, when selecting rows
in the second session, the select statement retrieves only rows created
in the second session.
The temporary table must be removed using the following sequence of
steps. These steps are needed because one session cannot drop a temporary
table that another session is using.
1.
In the second session
. TRUNCATE TABLE TEMP;
2.
In the first session
. TRUNCATE TABLE TEMP;
3.
In either session
. DROP TABLE TEMP;
