Answer Posted / 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;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does sql profiler affect performance?
What is full join in sql?
what is the use of friend function? : Sql dba
How delete all data from all tables in sql?
What are user defined functions?
What is a natural join sql?
Is time a data type in sql?
What are the types pl/sql code blocks?
What is the basic structure of an sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Explain the purpose of %type and %rowtype data types?
What is procedure function?
What is the difference between stored procedure and view?
Can you sum a count in sql?
Why should I use postgresql?
