Answer Posted / jijo
Global temporary tables are temporary table for perticular session.
Global temporary tables are two types,
1.Transaction wise temporary table
2.Session wise temporary tables.
In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.
In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.
Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
Do you know where we can check the status of po?
List the various types of value set.
What is instead of trigger in where we will use?
What are the Standard Reports and Forms in HRMS?
Tell me how to debug the report?
how do you describe O2C along with tables
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Can you differentiate between mediator and osb?
In hierarchical structure of a database? we have write query from where we should start?
what are the prerequisites for costing transactions?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Plz anybody send me Technical specification for AP Interface
How to move the one file from one instance to another instance? And your scripts also?
What is oracle soa suite?