Oracle Apps Question:
Download Job Interview Questions and Answers PDF
What is global tempory table?
Answer:
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.
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.
Download Oracle Applications Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the difference between format trigger and action trigger? | WHAT IS ACCOUNTING CONVENTION, WHY WILL WE USE IT? |