Posted by: vishnu patil
Date: November 29, 2012 12:46PM
I have table having two column tid,parent
data is mapped as chiled, parent like (tid, parent) (800,0)(810,800)(820,800)(811,810)(811,6457)(808,0)(830,808)(840,808)(5524,830) so on
i want to get data all tid of 807 or 808 etc
this list i need to use in other query's where condition
i try to write function using Group Concat it is fetching records if function directly run but in where codition it is not working
Please help it is urgen
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.