Skip to Main Content

SQL & PL/SQL

Announcement

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!

Why with clause not working on oracle 21.3.0.0 but working on 19.3.0.0?

User_ZR3PEDec 1 2022

WITH DS AS ( SELECT 1*1 ER FROM DUAL)
SELECT * FROM DS;
This works on Oracle 19c but not works on latest 21c version? What might be the problem?
image.pngimage.png

This post has been answered by Frank Kulash on Dec 1 2022
Jump to Answer
Comments
Post Details
Added on Dec 1 2022
9 comments
499 views