what is global table

Answer Posted / rk

Global temporary tables are distinct within SQL sessions.

The basic syntax is:

CREATE GLOBAL TEMPORARY TABLE table_name ( ...);

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write pl sql program in mysql command prompt?

513


Can we use insert statement in function?

514


What does select count (*) mean in sql?

545


Can you have a foreign key without a primary key?

507


What are the two parts of design view?

579






What is dense_rank?

536


What is difference between stored procedures and application procedures?

567


Explain how can you save or place your msg in a table?

593


What is blind sql injection?

572


How to use sql statements in pl/sql?

578


What is the difference between explicit and implicit cursors in oracle?

513


What are views in sql?

543


What is the difference between function, procedure and package in pl/sql?

556


What does dml mean?

543


What is offset in sql query?

593