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!

Add zeros dynamically after a number

586006Sep 15 2013 — edited Sep 15 2013

Hi,

I require some help in writing this query.

I want to add number of zeros after a number dynamically.

eg: If number is 2 and number of zeroes to be added is 5 then final output should be 200000;

This post has been answered by chris227 on Sep 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2013
Added on Sep 15 2013
12 comments
522 views