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 the clause we need to add in function body to return variable?
How does sql developer connect to oracle database?
What are views in sql?
What is bind reference and how can it be created?
What is sorting in sql?
What is pls_integer in pl sql?
What are the types pl/sql code blocks?
What are character functions in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is crud diagram?
what does the t-sql command ident_incr does? : Transact sql
How to return multiple rows from the stored procedure?
Is foreign key mandatory?
Are there any features that are decommissioned in 11g that are not present in 11g?
how to use myisamchk to check or repair myisam tables? : Sql dba