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 delete command in sql?
How to load data with sql*loader?
What is a common use of group by in sql?
Is there a 64 bit version of ssms?
What is PL/SQL Records?
What are the usages of sql?
What are records give examples?
What are different types of queries in sql?
How do I view output in sql developer?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Define implicit and explicit cursors.
How do I start sql profiler?
What is normalization sql?
Write a unique difference between a function and a stored procedure.
What is linq to sql?