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!
How to display the number '1234' as row by row using level or union all operator in Oracle? I have tried like below it is working as expected select substr('12345',rownum,1) from all_objects where rownum <=length('12345')