Select Query
Posted by:
Gopi L
Date: November 05, 2009 07:51AM
Hi I have a table with 5 columns. And there is a "select count(*) from another_table..." query in one of the field, assume its col5. By running this query it will return a zero or non zero.
I wanted to run a query like
SELECT * FROM T1 WHERE COL1=1 AND COL2='N' AND COL5>0 - where col5 result would be the result of executing the query inside it.
How do I do this? Any suggestions please...
Subject
Written By
Posted
Select Query
November 05, 2009 07:51AM
November 05, 2009 08:16AM
November 06, 2009 12:03AM
November 06, 2009 03:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.