OraFAQ Forum: SQL & PL/SQL » Format problem........

Home » SQL & PL/SQL » SQL & PL/SQL » Format problem........

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format problem........ [message #247462]

Tue, 26 June 2007 00:35

lokhande.dinesh29
Messages: 36
Registered: May 2007

Member

Hi All,

I want to print number 65746 in this format 657-46.
What will be the way for this...?

Regards,
Din

Report message to a moderator

Re: Format problem........ [message #247464 is a reply to message #247462]

Tue, 26 June 2007 00:44

Frank
Messages: 7901
Registered: March 2000

Senior Member

Here are the steps I followed:
1) I show how to use a format mask using group separator
2) I show how to (normally) redefine the symbol used for group- and decimal separator
3) I use the symbol '-' as group separator

SQL> select to_char(12345, '999G99') from dual;

TO_CHAR
-------
 123,45

SQL> select to_char(12345, '999G99', 'nls_numeric_characters='',.''') from dual;

TO_CHAR
-------
 123.45

SQL> select to_char(12345, '999G99', 'nls_numeric_characters='',-''') from dual;

TO_CHAR
-------
 123-45

Report message to a moderator

Previous Topic:	need to merge the records
Next Topic:	to know table name of specific data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 00:31:20 CST 2024