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!

Generate Sequence Using Pattern

ponicpoolDec 21 2018 — edited Dec 25 2018

I would like to generate number in the below range using a PLSQL block

00.000000

to

99.999999

How can I do this?

I tried with the below, upto 999 as sample but could not get the correct output

BEGIN

   FOR idx IN 00 .. 999

   LOOP

      DBMS_OUTPUT.put_line ('.' || idx);

   END LOOP;

END;

/

Appreciate any help.

This post has been answered by mathguy on Dec 21 2018
Jump to Answer
Comments
Post Details
Added on Dec 21 2018
33 comments
1,157 views