When are they useful justify with an example, Database Management System

Assignment Help:

When are they useful? Justify with an example.

The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent table, a space is not allocated to a temporary table while it is established. Space will be dynamically allocated for the table as rows are inserted. The

CREATE GLOBAL TEMPORARY

TABLE command is used to create a temporary table in Oracle.

CREATE GLOBAL TEMPORARY TABLE (

) ON COMMIT {PRESERVE|DELETE} ROWS;

Related Discussions:- When are they useful justify with an example

Which data type can store unstructured data, Which data type can store unst...

Which data type can store unstructured data? Raw data type can store unstructured data.

Which are two ways that entities participate relationship, Which are the tw...

Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship

Differentiate between procedural and non procedural language, Differentiate...

Differentiate between Procedural and non procedural languages ? Procedural and non procedural languages - A procedural language specifies the operations to be performed on th

Explain two phase locking protocol, Explain Two phase locking protocol ...

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

Design a gennalization and specialization hierarchy for an a, Design a genn...

Design a gennalization and specialization hierarchy for an automobile sales company

What is the difference between serial and sequential files, What is the dif...

What is the difference between serial and sequential files? How searching is applied on both? Ans: A serial file is one where the records have been stored in the order where

Explain traditional programming languages, How persistent programming langu...

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

Marketing interface, as a customer service employee explain five measures y...

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

Working and processing files, 1. Define each of the following IN YOUR OWN ...

1. Define each of the following IN YOUR OWN WORDS: (a) File: (b) Record: (c) Field: (d) Primary Key: (e) Secondary Key: 2. A travel agency wants t

Design and building a distributed information system, prototype of a distri...

prototype of a distributed information system for a national car part retail outlet chain.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages