update query
Hi Everybody,
I have a table having a column as varchar2.The column has at present data of many rows.
The data stored in the column are for e.g..
10
2508
NU-CMA13
1
45
....
....
Now i want to update the column data like wherever there are numeric data like 10 it needs to be updated as 4 digit(padded with 2 leading zeroes) so the data should look like...
0010
2508
NU-CMA13
0001
0045
....
....
Pls if anybody kknows the solution...Thanks in advance
pras
Dream as if u'll live forever..Live as if u'll die today.