Hi, I have a number field with data ex: "12345678". Need to add two zeros like this. "1002345678". I have given example of just one row but need to add this zeros for all the columns in the table. Kindly suggest on this

You show these 'numbers' as strings; are they actually numbers or are they in a varchar2 column? If they are actually numbers, are all the same length and start with 1 the easiest way is to simply add 990000000 to each value. If they are strings (which is not a good way to store actual numbers then the previous response is what you want. Of course if these ARE numbers and are of varying values with nothing but being numbers in common then you will need to use substr() on them, generate your new number then convert it back to a number: Code (SQL): UPDATE mytable SET mynum = to_number(substr(mynum,1,1)||'00'||substr(mynum, 2, LENGTH(mynum)-1)); The above may be easier than computing the difference between the desired number and the existing value and adding.