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!

select * from dual

user13328581Nov 21 2019 — edited Nov 21 2019

Hello Experts;

Just out of curiosity why does

select * from dual

return  x

on

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

"CORE    12.2.0.1.0    Production"

TNS for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

This post has been answered by L. Fernigrini on Nov 21 2019
Jump to Answer
Comments
Post Details
Added on Nov 21 2019
8 comments
18,159 views