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!

Sql Query to find increment of a number using select Statement

User_40B57Sep 3 2020 — edited Sep 4 2020

Summary:

I need a select query which should provide me a output with increment for the number (0001). Suggest a query which apt for the below expected output without using Sequence conditions.

Expected output:

TO_CHAR('0001')
0001
0002
0003

Query:

select to_char('0001') from dual;

Thanks,

Hema.

Added on Sep 3 2020

#sql-pl-sql

7 comments

13,323 views