Home » SQL & PL/SQL » SQL & PL/SQL » I need real examples for Temporary Tables (10g)
I need real examples for Temporary Tables [message #361543] Wed, 26 November 2008 21:48 Go to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi
I need realistic examples for Temporary Tables

CREATE GLOBAL TEMPORARY TABLE table_name
(column1 datatype1 [DEFAULT expression] [, ......])
ON COMMIT PRESERVE ROWS;


http://download.oracle.com/docs/cd/B19306_01


as data exists only for the duration of a transaction or session.
the same TEMPORARY TABLE has different data for different sessions or users , data are available only for its session or user.


then
what are the benefits of TEMPORARY TABLES ?
and in case of applications, why do we have to use it & how?

thanks

Re: I need real examples for Temporary Tables [message #361580 is a reply to message #361543] Thu, 27 November 2008 01:07 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read this
Previous Topic: Display rows according to specific conditions in resultset
Next Topic: ORA-22922
Goto Forum:
  


Current Time: Fri Dec 02 20:40:03 CST 2016

Total time taken to generate the page: 0.09600 seconds