| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem in manipulating a record
"Sandy80" <svarshneymail_at_gmail.com> a écrit dans le message de news: 1174900357.635066.243210_at_y66g2000hsf.googlegroups.com...
| Hi,
|
| I have a requirement to manipulate a record as follows:
|
| If the record is 22.85 I need to generate the value 0228500 from this
| record i.e. I need to take 3 values before the decimal point and 4
| values after the decimal point replacing any missing value with a
| zero.
| I am doing the manipulation as follows:
|
| nvl(lpad(substr (rul.mid_value,0,INSTR(rul.mid_value, '.')-1 ),3,0) ||
| rpad(substr (rul.mid_value,INSTR(rul.mid_value, '.')+1,4),
| 4,0),'0000000')||
|
| Now the issue is that I have a record as 22 which does not have a
| decimal point and that is why the above manipulation is failing. The
| record cannot be changed and I somehow need to change my manipulation.
|
| Any ideas??
|
| Thanks,
| Sandy
|
SQL> select replace(to_char(22.85,'fm000.0000'),'.','') from dual; REPLACE(T
1 row selected.
SQL> select replace(to_char(22,'fm000.0000'),'.','') from dual; REPLACE(T
1 row selected.
Regards
Michel Cadot
Received on Mon Mar 26 2007 - 05:08:37 CDT
 |
 |