OraFAQ Forum: Forms » Oracle Developer Forms 6i

Home » Developer & Programmer » Forms » Oracle Developer Forms 6i - Execute Query distinct rec (oracle developer form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Developer Forms 6i - Execute Query distinct rec [message #343055]

Tue, 26 August 2008 02:04

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....

Report message to a moderator

Re: Oracle Developer Forms 6i - Execute Query distinct rec [message #344448 is a reply to message #343055]

Fri, 29 August 2008 16:34

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	forms&reports
Next Topic:	form error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 08:08:01 CST 2025