Home » Developer & Programmer » Forms » how to create global pl/sql table in form
how to create global pl/sql table in form [message #387636] Fri, 20 February 2009 02:54 Go to next message
drajeshonline
Messages: 11
Registered: February 2009
Junior Member
Hi Everybody,

I need help on creating PL/SQL table so that i can retain the table value for the entire session,..

Thanks in advance,.
Re: how to create global pl/sql table in form [message #387658 is a reply to message #387636] Fri, 20 February 2009 03:43 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you consider using a global temporary table?
Re: how to create global pl/sql table in form [message #387666 is a reply to message #387658] Fri, 20 February 2009 04:08 Go to previous messageGo to next message
drajeshonline
Messages: 11
Registered: February 2009
Junior Member
can you please tell me how to achive using GTT,....
Re: how to create global pl/sql table in form [message #387671 is a reply to message #387636] Fri, 20 February 2009 04:19 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Achieve what?

You create a global temp table, you insert data into it, you query data back out, data exists for life of session.

Read up on global temporary tables in the documentation.
Previous Topic: excel to forms
Next Topic: How to stop inserting new record in tabular form based on specific condition
Goto Forum:
  


Current Time: Sun Dec 11 04:22:38 CST 2016

Total time taken to generate the page: 0.11125 seconds