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
Explain the components of sql?
What is embedded sql in db2?
Can you do multiple joins in sql?
Why do we need cursors in pl sql?
what is a primary key? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
Describe different types of general function used in sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Is hadoop a nosql?
What is query execution plan in sql?
Is oracle and sql same?
What are the different ways to optimize a sql query?
How do I copy a table in sql?
What happens when a trigger is associated to a view?
How run sql*plus commands that are stored in a local file?