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!

what is the way to generate one blank row from query when no data is fetch from table

ReemaPuriOct 17 2019 — edited Oct 17 2019

i was using this method but it is producing  blank row everytime even with data

select column1,column2 from table1

union all

select null,null from table1

This post has been answered by L. Fernigrini on Oct 17 2019
Jump to Answer
Comments
Post Details
Added on Oct 17 2019
7 comments
6,303 views