OraFAQ Forum: Forms » FROM clause query (Database Block)

Home » Developer & Programmer » Forms » FROM clause query (Database Block)

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

FROM clause query (Database Block) [message #201924]

Tue, 07 November 2006 07:28

marlon_loyolite
Messages: 66
Registered: July 2006

Member

Hi Friends,
I have a Database block having FROM clause query.
My question is can we filter the records by a column that has not been selected in the FROM clause query.

Or else do we have any other alternative.Because I use DISTINCT in the query which results in duplicate records.

Regards,
Marlon.

Report message to a moderator

Re: FROM clause query (Database Block) [message #201928 is a reply to message #201924]

Tue, 07 November 2006 07:41

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi Marlon,

u can here is the example

select empno,ename from emp where deptno=10;

You can check it yourself.

Bye
Ashu

Report message to a moderator

Re: FROM clause query (Database Block) [message #202019 is a reply to message #201924]

Tue, 07 November 2006 21:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'from clause query'. There are plenty of threads including some with worked examples.

David

Actually search for QUERY_DATA_SOURCE_NAME and look at attachment in http://www.orafaq.com/forum/t/53596/67467/

[Updated on: Tue, 16 January 2007 17:33]

Report message to a moderator

Previous Topic:	login screen
Next Topic:	Forms Documentation.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 21:45:23 CDT 2025