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!

Append 0's infront of number

ThejSep 10 2013 — edited Sep 10 2013

Hi Experts,

I have a table which containd 10 column.

One of the column contains numbers.

Now I have to append "0" s infront of these no's for all rows in a table .

can some one help me out.

sample column data as below

MSIDNO

------------------

817600810

614201429

815795262

614019116

817121742

813167782

815122985

614152719

767433893

614323233

814582410

814850162

815986700

817304479

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2013

Added on Sep 10 2013

13 comments

6,742 views