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!
We use XSLT to convert xml + xsl to pdf and other formats like EXCEL today. Since XSL is discontinued, we are looking for new ways to achieve the same functionality of publishing paged media.Thanks.
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.