Re: Problem in manipulating a record
- From: "Michel Cadot" <micadot{at}altern{dot}org>
- Date: Mon, 26 Mar 2007 12:08:37 +0200
"Sandy80" <svarshneymail@xxxxxxxxx> a écrit dans le message de news: 1174900357.635066.243210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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
---------
0228500
1 row selected.
SQL> select replace(to_char(22,'fm000.0000'),'.','') from dual;
REPLACE(T
---------
0220000
1 row selected.
Regards
Michel Cadot
.
- Follow-Ups:
- Re: Problem in manipulating a record
- From: Sandy80
- Re: Problem in manipulating a record
- References:
- Problem in manipulating a record
- From: Sandy80
- Problem in manipulating a record
- Prev by Date: Problem in manipulating a record
- Next by Date: Re: Problem in manipulating a record
- Previous by thread: Problem in manipulating a record
- Next by thread: Re: Problem in manipulating a record
- Index(es):
Relevant Pages
|
