Answer / pooja

Global temporary tables
All data stored in a global temporary table is private to
the session that has inserted (or updated) it.
Other sessions can't see this data. Global temporary tables
come in two flavors:
on commit preserve rows and on commit delete rows.
DDLs (such as drop table) on a on commit preserve rows lead
to a ORA-14452
when the session has already made a DML on the table.
Object tables

Answer / rk

Global temporary tables are distinct within SQL sessions.

The basic syntax is:

CREATE GLOBAL TEMPORARY TABLE table_name ( ...);

Answer / naresh reddy

The statement to create a global temporary table (GTT) is similar to the definition of an ordinary table with the addition of the keywords GLOBAL TEMPORARY. In the clause ON COMMIT, you specify if a table is bound to a transaction (DELETE ROWS) or to a session

Answer / vijay

1.global temporary table is a schema object
2.global temporary table record is store in session level but not store in database
3.global temporary table structure of the table is store in database but record not store in database
4.global temporary table record not shown one session to another session level
5.it is used reporting purpose temporarily record saved in session level
Two types
1.on commit delete rows( all records deleted structure of table only shown)
2.on commit preserve rows(record saved in session level (once login &logout record gone)
create global temporary table table_name on commit preserve rows as select * from employees;

Answer / subhendu

Features:
1. If the TRUNCATE statement is issued against a temporary
table, only the session specific data is trucated. There is
no affect on the data of other sessions.

2. Data in temporary tables is automatically delete at the
end of the database session, even if it ends abnormally.

3. Indexes can be created on temporary tables. The content
of the index and the scope of the index is that same as the
database session.

4. Views can be created against temporary tables and
combinations of temporary and permanent tables.

5. Temporary tables can have triggers associated with them.
Export and Import utilities can be used to transfer the
table definitions, but no data rows are processed.

Answer / rajeev kumar

A global table is a dummy table. which is available until
the sql server is on.

Answer / harshali

global table is access by all users

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

Which one is faster ienumerable or iqueryable?

0 Answers  

What is dialect in sql?

0 Answers  

What is optimistic concurrency control? : Transact sql

0 Answers  

What is plpgsql language?

0 Answers  

What is union, minus and interact commands?

0 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

what is a primary key? : Sql dba

0 Answers  

What is pl sql in oracle?

0 Answers  

what is error ora-03113: end-of-file on communication channel?

0 Answers