Database Reference
In-Depth Information
Figure 18.8
Create a Temporary
Table and Add
Some Rows in the
First Session.
logged in as MUSIC in both sessions, both sessions share the same schema
and can use the TEMP table.
We then insert four rows into the TEMP table in the second session
with values 1, 4, 5, and 6 in the column, and then commit the transaction
and query the TEMP table once again. The result is shown in Figure 18.9.
Here are some important points demonstrated in this example:
Rows added in either of the two sessions are not visible to the other
session; only the structure of the table is visible to both sessions.
The row value 1 in the first session and the second session are not the
same rows, even though their values are the same.
 
Search WWH ::




Custom Search