GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  D2K
Go To First  |  Previous Question  |  Next Question 
 D2K  |  Question 41 of 71    Print  
what is the global temporary variable

  
Total Answers and Comments: 5 Last Update: August 07, 2008     Asked by: sankarreddy 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 21, 2006 03:57:59   #1  
rajesh        

RE: what is the global temporary variable

Global Temporary tables are Session based tables


 
Is this answer useful? Yes | No
February 27, 2007 05:04:37   #2  
surendra_mohan        

RE: what is the global temporary variable
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.

 
Is this answer useful? Yes | No
October 07, 2007 16:12:41   #3  
osden        

RE: what is the global temporary variable
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

 
Is this answer useful? Yes | No
February 22, 2008 06:26:42   #4  
jagadeesh9 Member Since: February 2008   Contribution: 27    

RE: what is the global temporary variable

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(-----)


 
Is this answer useful? Yes | No
August 06, 2008 13:52:13   #5  
Raghu2008 Member Since: August 2008   Contribution: 9    

RE: what is the global temporary variable
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.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape