Skip to Main Content

Breadcrumb

Warning

Before you submit your comment...

Remember - this is about feedback to the original question. AskTOM is about building a strong Oracle community, not stealing time away from others needing assistance by sneaking in a brand new question under the guise of "Comment".

If your comment requires a response that might include a query, please supply very simple CREATE TABLE and INSERT statements. Nice simple scripts so we can replicate your issue simply.

Remember to take a look at Legal Notices and Terms of Use before supplying a comment...

Don't forget, your comments are public. If you want to send a comment to just the AskTOM team, please use the feedback option

Comment

Highlight any SQL, PL/SQL, or fixed-width text and click the <code> button
 (will never be published or used to spam you)

Question and Answer

Connor McDonald

Thanks for the question, Lukas.

Asked: August 20, 2018 - 9:14 am UTC

Last updated: August 22, 2018 - 2:05 am UTC

Version: 18.0.0.0.0

Viewed 1000+ times

You Asked

According to the documentation, a lot of multiset conditions should also work with varrays, which they don't (at least not in the SQL language):
https://docs.oracle.com/database/121/SQLRF/conditions006.htm#SQLRF52138

I've created a Stack Overflow question which illustrates what I mean:
https://stackoverflow.com/q/51837804/521799

I guess this is a documentation bug?

and Connor said...

Definitely a doc bug. Because even the syntax diagram explicitly notes nested table

MULTISET_SYNTAX

I've logged it with the doc team.

Is this answer out of date? If it is, please let us know via a Comment