what is global table

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


Please Help Members By Posting Answers For Below Questions

Can a primary key be a foreign key?

575


How we can update the view?

599


what are numeric data types? : Sql dba

574


What is clustered and nonclustered index in sql?

495


What does desc stand for?

588






Which constraints we can use while creating database in sql?

611


What is the maximum number of rows in sql table?

545


what is a table in a database ? : Sql dba

540


How do I add a database to sql?

576


Is it important to partition hard disk?

532


What is a full join?

521


How do I save the results of sql query in a file?

533


What is the purpose of normalization?

531


How can I get the number of records affected by a stored procedure?

570


What are %type and %rowtype for?

613