Answer Posted / naresh reddy
The statement to create a global temporary table (GTT) is similar to the definition of an ordinary table with the addition of the keywords GLOBAL TEMPORARY. In the clause ON COMMIT, you specify if a table is bound to a transaction (DELETE ROWS) or to a session
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is a trigger in mysql? : Sql dba
how to get help information from the server? : Sql dba
How can I change database name in sql?
What does partition by mean in sql?
What is ttitle and btitle?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what are the types of subquery? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are the two types of exceptions in pl/sql?
Explain the steps needed to create the scheduled job?
what are the differences between char and varchar? : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is posting?
How do I delete a trigger?
How do I count rows in sql query?