I have a table of entries from SQL server called PID. Each of this entry should follow the following
select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid'
Where I have '0' in the query above, should take all the values from PID.
Is there a easy way to write this? or should I loop through the query like
foreach ( value from arraylist)
select * from HR.TABLES a START WITH a.SID = 'value' CONNECT BY PRIOR a.parentid = a.sid'
IN short I need to do something like above and I am really tired thinkin about it for past 2 days. Please help .
THanks in advance