Format Mask to currency [message #360467] |
Fri, 21 November 2008 02:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
DRASTANT
Messages: 21 Registered: July 2007 Location: KENYA
|
Junior Member |
|
|
Hi all
i am trying to put *** as my fillers. i.e total size for my character field is 15 if the ammount is coming to 6 digits it should put remaning fields as ********. Can i do this using format mask.
pls assist
thanks
drastant
|
|
|
|
|
Re: Format Mask to currency [message #360523 is a reply to message #360467] |
Fri, 21 November 2008 04:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
Prints one digit, unless it is a leading zero
to the left of the decimal
point,
in which case an
asterisk (*) is printed.
Trailing zeros to the right of the
decimal point are printed.
Open the oracle report and go to format mask property , Press F1
and Click the Number Format Mask. You will get all formats there.
[Updated on: Fri, 21 November 2008 04:41] Report message to a moderator
|
|
|
Re: Format Mask to currency [message #379646 is a reply to message #360467] |
Wed, 07 January 2009 07:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
DRASTANT
Messages: 21 Registered: July 2007 Location: KENYA
|
Junior Member |
|
|
Thanks for your assistance but after long trouble shooting i have found out my ammount field is charcter format it does not have option of format mask
please help urgently
thanks
drastant
|
|
|
Re: Format Mask to currency [message #379689 is a reply to message #379646] |
Wed, 07 January 2009 12:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Why do you store numbers into character columns?
Remedy might be simple (if I understood the problem, that is): use the LPAD function:SQL> WITH TEST AS
2 (SELECT '12345' amount FROM dual UNION
3 SELECT '12,345' FROM dual UNION
4 SELECT '12,345.67' FROM dual
5 )
6 SELECT amount, LPAD(amount, 12, '*') result
7 FROM TEST;
AMOUNT RESULT
--------- ------------------------------
12,345 ******12,345
12,345.67 ***12,345.67
12345 *******12345
SQL>
[EDIT]DRASTANT | please help urgently
|
What do you mean by saying that? It took you almost 2 months to reply to previous message! Therefore, it doesn't seem to be that urgent. Besides, lack of planing on your side certainly doesn't imply urgency on my side.
[Updated on: Wed, 07 January 2009 12:06] Report message to a moderator
|
|
|
Re: Format Mask to currency [message #379818 is a reply to message #360467] |
Thu, 08 January 2009 00:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
DRASTANT
Messages: 21 Registered: July 2007 Location: KENYA
|
Junior Member |
|
|
littlefoot
I am really sorry for that comment as this was out of our agenda for some time.
Now the pervois format mask property which i applied on number field as you suggested _*********** when i exceute the report it only prints the leading two digits and rest as '*' for e.g if i print 12,678.87 then it prints only **********12
kinldy asssist.
thanks
drastant
|
|
|
|
Re: Format Mask to currency [message #380367 is a reply to message #379818] |
Sun, 11 January 2009 07:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
|
Drashtant,
Which One you are trying the Format mask or the LPAD?
LF Suggested to Use a LPAD Simply Check man...
select LPAD(sal, 15 ,'*') from emp
I thought u allready got your Idea.
Javed
|
|
|