Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

23c documentation bug in multi_table_insert and conditional_insert_clause

With 23c the existing values_clause used in the insert statement was renamed to insert_values_clause. The new values_clause is part of the table value constructor introduced in 23c.

See for 23c: https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/INSERT.html#GUID-903F8043-0254-4EE9-ACC1-CB8AC0AF3423__GUID-189C3414-46E8-4EF2-8E10-03483DD68F6E

See for 21c: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/INSERT.html#GUID-903F8043-0254-4EE9-ACC1-CB8AC0AF3423__GUID-189C3414-46E8-4EF2-8E10-03483DD68F6E

The railroad diagrams still reference the values_clause. However, the link below the figures correctly reference the new insert_values_clause.

This post has been answered by Chris Saxon-Oracle on Jan 22 2024
Jump to Answer
Comments
Post Details
Added on Jan 19 2024
5 comments
194 views