rajesh

• Dec 21st, 2006

 

Global Temporary tables are Session based tables

surendra_mohan

• Feb 27th, 2007

 

global temporary is session based and transaction based table for that
table some restriction also there as a like we can not use referential integrity(foreign key) on that table.

osden

• Oct 7th, 2007

 

A Global variable is oracle forms variable whose value is accessible to triggers and subprograms in any module that is active during the current session.

It stores Character String up to 255 char in length

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 22nd, 2008

 

We r write pl/sql procedure r package
only that particular session we use global temparary table once the session complete then global temparary table will be delected automatically.
syn:Create global temparary table(-----)

Raghu2008

 Profile Answers by Raghu2008 

• Aug 6th, 2008

 

A global variable is used to store charecter value upto 255 in length. It can be access throught the form module. The global variable always prefixed with ':Global.'

Thanks
Raghu.