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

What are the kinds of strings, What are the kinds of Strings? -A binar...

What are the kinds of Strings? -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Joins, how can apply joins on table

how can apply joins on table

What is a transaction? and how does it differs from update, wh

Non-query optimisations, Part: Recommended (Non-query) Optimisations Thi...

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

Creating a view-data control, Creating a view: A query can be embed...

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer

Adjustments are required to increase chances of inheritance, What types of ...

What types of adjustments are required to increase chances of inheritance. a) Some attributes can be added or ignored in the base class operation b) Some changes can be

Parallelism of transaction execution-data fragmentation, Parallelism of tra...

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

The first normal form (1nf), The First Normal Form (1NF) Let us first d...

The First Normal Form (1NF) Let us first describe 1NF: Definition: A relation (table) is in 1NF if 1. There are no duplicate tuples or rows in the relation. 2.

Create role named roletable to allows a user to create table, Create role n...

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

Write a short note on built in function in qbe, Write a short note on built...

Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages