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
Messages: 66
Registered: July 2006
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.

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

Re: FROM clause query (Database Block) [message #202019 is a reply to message #201924] Tue, 07 November 2006 21:45 Go to previous message
Messages: 10180
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.


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: No of detail block records.
Next Topic: scroll bar
Goto Forum:

Current Time: Tue Aug 22 02:22:21 CDT 2017

Total time taken to generate the page: 0.01113 seconds