In Oracle8i or later versions, you can create the following two types of temporary tables:
1. Session-Specific temporary tables
CREATE GLOBAL Temporary ()On COMMIT PRESERVE ROWS;
2. Transaction-specific temporary tables
CREATE GLOBAL Temporary
Reprint Address: http://www.cnblogs.com/kerrycode/p/3285936.htmlTemporal table ConceptsA temporary table is a database object that is used to temporarily save temporary data (or intermediate data), which is somewhat similar to a normal table, but is
Temporal table ConceptsA temporary table is a database object that is used to temporarily save temporary data (or intermediate data), which is somewhat similar to a normal table, but is quite different. It can only be stored in a temporary table
1. The temporary table's basic knowledge temporary table is supported only in oracle 8i and above products. Oracle databases can also create temporary table temporary tables, in addition to saving permanent tables. These temporary tables are used
1, the concept of temporary table
Temporary table (Global temporary table): Online shopping for e-commerce
Temporary tables are used to store private data for a session or transaction. Once a temporary table is established, its structure persists,
Temporary files generated during software installation
When installing many software, first extract the installation file to a temporary directory (usually the temp directory under the Windows folder), such as WinZip and other tools, and then
Whether friends have this experience, with the longer use of computers, system partition is less available space, the reason for this situation in addition to the frequent installation of some software, there is a very important reason, that is,
When you work on a large table, you may occasionally need to run many queries to obtain a small subset of a large amount of data, instead of running these queries on the entire table, instead, MySQL can find a few required records each time, and it
If the content is not good, please forgive me
To meet project requirements, we need to create temporary tables and temporary functions in a stored procedure to merge the return tables of N tables in a stored procedure. This creates a lot of trouble,
In Windows, temporary files are available everywhere, IE also has its own temporary folder. Here, let's look at the temporary folder for IE. Know the IE Temp folderWhen you enter the Web site in the IE address and return, ie first in your hard
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.