For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi, Would highly appreciate if someone kindly confirm that Oracle Developer 10g work with Oracle Database 11g R1 and R2?
Regards, Shamir
I think that is possible in 18c (maybe 12.1). At least in a very similar way. We can declare a local plsql collection and then do a select .. .from table(collection); Without the need to declare an object type in SQL.
See this example in LiveSQL (statement 10):
https://livesql.oracle.com/apex/livesql/file/content_CHREI3LLPBLRAHQR9TDJIO677.html
So while I think this is a good idea, it should also be marked as "already implemented".
Will it work for complex query's . if so it will be more useful.