Forum Stats

  • 3,875,570 Users
  • 2,266,947 Discussions
  • 7,912,257 Comments

Discussions

Clarify the docs: TABLE() keyword for table collection expressions is now optional

User_1871
User_1871 Member Posts: 247 Red Ribbon

Previously, Table() was necessary for cases like this:

SELECT *
FROM   TABLE(SYS.ODCIVARCHAR2LIST('a', 'b', 'c'));

COLUMN_VALUE
a
b
c

Now (possibly at 12.2), Table() is optional:

SELECT *
FROM   SYS.ODCIVARCHAR2LIST('a', 'b', 'c');

COLUMN_VALUE
a
b
c

Could the docs be improved to make that clearer?

https://community.oracle.com/tech/developers/discussion/4499629/at-what-version-did-the-table-keyword-for-table-collection-expressions-become-optional/p1?new=1

User_1871mathguySven W.
3 votes

Active · Last Updated