Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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.

Comments
Post Details
Added on Sep 3 2020
7 comments
10,164 views