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 unit of measure classes? give atleast two examples. name the underlying table.
what are the different types of triggers in reports
why we can use synonym?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
what is the standard program for blanket po to process data from interface table to bace table
how do you describe O2C along with tables
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
What is SET-OF-BOOKS?
What are the files you have used in the part of Conversion and Interfaces?
Give a brief overview on OrderManagement.
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?