Described 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:
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:
Read Online Application Developer Job Interview Questions And Answers
Top Application Developer Questions
☺ | Explain SAP R/3? |
☺ | Described global tempory table? |
☺ | What is WF and WF importance? |
☺ | If the client is totally dependent on manual on Manual transactions then Is the auto-accounting rules Mandatory? |
☺ | Explain Bex? |
Top Coding/Programming Categories
☺ | Python Interview Questions. |
☺ | OOP Interview Questions. |
☺ | Software engineering Interview Questions. |
☺ | PHP Interview Questions. |
☺ | VBA (Visual Basic for Applications) Interview Questions. |