What is global tempory table?
Submitted by: AdministratorGlobal 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle Apps Job Interview Questions And Answers
Top Oracle Apps Questions
☺ | What is the difference between workday calendar and accounting calendar? |
☺ | Differentiate between intra & inter UOM class conversion with examples? |
☺ | Is UOM maintained at master level or organization level or both? |
☺ | What is automatic offset in AP? |
☺ | Name of the reports in oracle inventory related to transaction? |
Top Oracle Applications Categories
☺ | Oracle Apps Manufacturing Interview Questions. |
☺ | Oracle Apps Technical Interview Questions. |
☺ | Oracle Apps Financial Interview Questions. |
☺ | Oracle Apps SCM Interview Questions. |
☺ | Oracle Apps CRM Interview Questions. |