Home » Developer & Programmer » Forms » FROM clause query (Database Block)
FROM clause query (Database Block) [message #201924] Tue, 07 November 2006 07:28 Go to next message
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.
Re: FROM clause query (Database Block) [message #201928 is a reply to message #201924] Tue, 07 November 2006 07:41 Go to previous messageGo to next message
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
Re: FROM clause query (Database Block) [message #202019 is a reply to message #201924] Tue, 07 November 2006 21:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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:
  


Current Time: Mon Dec 05 04:39:03 CST 2016

Total time taken to generate the page: 0.11407 seconds