what is global tempory table?
Answer / 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 |
what is the back ground program run while transferring data from OM to AR?
what is the difference between request group and request security group in oracle apps?
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
in one report using two layout models.if yes how to do
Explain the multi-organization structure.
What is oracle soa suite?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
wht is format triger?
how to set org context?
when we run payment batch what are the 3 concurrent programs?
Can anybody tell me, What is the Implementation Process?