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
what is myisam? : Sql dba
What is the main reason behind using an index?
What is structural independence and why is it important?
How many sql statements are used?
Whis is not false in primary key?
Does sql between include endpoints?
What is the difference between syntax error and runtime error?
how to do backup entire database? : Transact sql
Is left join faster than join?
What does seeding a database mean?
Can you upgrade sql express to full sql?
What is trigger in sql?
Why are cursors used?
Differentiate between sga and pga.
what are the authentication modes in sql server? : Sql dba