Home » Developer & Programmer » Forms » forms (10g)
forms [message #488830] Tue, 11 January 2011 07:37 Go to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
How can be create temporary objects through forms 10g?

In oracle we can create a temporary table so similarly by using forms_ddl can we create a temporary table?

Are there any other temporary objects?

Report message to a moderator

Re: forms [message #488832 is a reply to message #488830] Tue, 11 January 2011 07:41 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can but you shouldn't. The point of global temporary tables is that the structure is permanent and the data is temporary. Creating them at run time is almost always unecessary and more trouble than it's worth.

Report message to a moderator

Re: forms [message #488884 is a reply to message #488832] Tue, 11 January 2011 23:54 Go to previous messageGo to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
This was asked from me in an interview. So I want to know that how temporary objects are created? Others things are secondary . So I woule like to confirm will it be through forms_ddl only?

Report message to a moderator

Re: forms [message #488893 is a reply to message #488884] Wed, 12 January 2011 01:24 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As GTTs actually ARE tables (created with CREATE GLOBAL TEMPORARY TABLE ...) - yes, FORMS_DDL is the way to do that.

Another option might be HOST built-in. CREATE statement would be saved in a file, and HOST would start SQL*Plus and run the file (i.e. the CREATE statement itself).

Report message to a moderator

Re: forms [message #488903 is a reply to message #488893] Wed, 12 January 2011 02:57 Go to previous messageGo to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
are there any other temporary objects other than a database table?

Report message to a moderator

Re: forms [message #488907 is a reply to message #488903] Wed, 12 January 2011 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Certainly. All those that you create, use for a while and then drop. But I don't know whether any of them are actually called "temporary" (except GTTs).

Report message to a moderator

Re: forms [message #488970 is a reply to message #488907] Wed, 12 January 2011 09:22 Go to previous messageGo to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
Please name those temporary objects

Report message to a moderator

Re: forms [message #488971 is a reply to message #488970] Wed, 12 January 2011 09:24 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Any db object can be created on the fly and then dropped, but it isn't advisable.

Report message to a moderator

Previous Topic: Post Query Trigger with cursor
Next Topic: application hanging when used by single user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:53:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.