Home » Developer & Programmer » Forms » Oracle Developer Forms 6i - Execute Query distinct rec (oracle developer form 6i)
Oracle Developer Forms 6i - Execute Query distinct rec [message #343055] Tue, 26 August 2008 02:04 Go to next message
mohibuddin
Messages: 1
Registered: August 2008
Location: Karachi
Junior Member
I am facing a problem that in the table there are many duplicate key records and I want to query the distinct records in a form block using execute_query. If anyone knows about it, so please help me...I am in urgency....
Re: Oracle Developer Forms 6i - Execute Query distinct rec [message #344448 is a reply to message #343055] Fri, 29 August 2008 16:34 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a view as
SELECT DISTINCT that_column 
FROM your_table
and use the view as data source for a data block. Or, use FROM CLAUSE query source (in there you can write your own query, but I believe that the first option is far simpler).
Previous Topic: forms&reports
Next Topic: form error
Goto Forum:
  


Current Time: Fri Dec 09 13:18:37 CST 2016

Total time taken to generate the page: 0.09056 seconds