Interested to Buy Any Domain ? << Click Here >> for more details...
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 an alias command?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Can we use ddl statements in stored procedure sql server?
What is the difference between local and global temporary table?
What is sql partition function?
What does := mean in pl sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what is the difference between char and varchar data types? : Sql dba
how to rename an existing column in a table? : Sql dba
What are triggers and its uses?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the difference between execution of triggers and stored procedures?
What is a unique key and primary key and foreign key?
What does subquery mean in sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
