Local temporary table in oracle 10g
Yep, Oracle has temporary tables. Here is a link to an AskTom article describing them and here is the official oracle CREATE TABLE documentation.. However, in Oracle, only the data in a temporary table is temporary. The table is a regular object visible to other sessions. It is a bad practice to frequently create and drop temporary tables in Oracle. The SQL standard, which defines how the term "GLOBAL TEMPORARY TABLE" is interpreted, allows for either a LOCAL or GLOBAL scope. This would allow for either a user specific table (LOCAL) or everyone (GLOBAL). Oracle implements only the GLOBAL version. The data you put into an Oracle Temporary table is specific to your session. ORACLE-BASE - Global Temporary Tables. Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 13c Oracle 18c Oracle 19c Miscellaneous PL/SQL SQL Oracle RAC A new variation of temporary tables has been introduced in Oracle 18c. A private temporary table is a memory-based temporary table that is dropped at the end of the session or.
It is remarkable, rather the helpful information
I think, that you are not right. Let's discuss it.
You are not right. Let's discuss. Write to me in PM.
I think, that you are not right. I can prove it. Write to me in PM, we will talk.
Completely I share your opinion. In it something is and it is good idea. It is ready to support you.