Home » Developer & Programmer » Forms » Database column in a non-database block
Database column in a non-database block [message #410808] Tue, 30 June 2009 06:34 Go to next message
Messages: 9
Registered: June 2009
Location: india
Junior Member
is it possible to read database column and display in non database block in oracle forms 10g Laughing
Re: Database column in a non-database block [message #410817 is a reply to message #410808] Tue, 30 June 2009 07:12 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sure; a simple
SELECT some_column
  INTO :block.item_name
  FROM your_table
  WHERE certain_condition
would do the job. Such a code can be part of numerous triggers (such as POST-QUERY, WHEN-VALIDATE-ITEM, etc.)

I understand that you are new on the OraFAQ Forum. Welcome!
Though, please, try to get familiar with certain rules that apply while staying here (i.e. read the OraFAQ Forum Guide). You have put this question into an ancient (dated in 2003!) topic which was not related to your problem in any way. In order to test your posting abilities, please, visit our Test forum (you'll find it at the bottom of the forum list).
Previous Topic: accomdating more than 70,000 rows in an excel
Next Topic: Menu Problem
Goto Forum:

Current Time: Sat Jul 22 06:12:03 CDT 2017

Total time taken to generate the page: 1.48873 seconds