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 |
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
where u do setup of operating unit?
what is item status? name the related table.
WHAT IS REFCURSOR IN ORACLE ?
What is profile and what is level of profile option and it's hierarchy
in which tables the transaction details stored? at least two.
Can we run a package with out specification?If yes how?
where to define interorganization transaction charges and what are the different options?
we have select statement in that two exceptions that returns no value. In that which exception will raise?
tell my any difficult situtation you solved in your experience in your company?
What are basic steps for AIM?
Oder of firing triggers in form