Re: Currency sign ($) in SQL*Plus

In article <175_at_along.dialix.oz.au>,
Alex Long <paladin_at_along.dialix.oz.au> wrote:
>Greetings,
>I have a puzzle that I need help with.
>When formatting a COLUMN statement (In SQL*Plus), I use the "$" sign to
>indicate a currency column, and it is pre-pended to the returned column.
>A client requires Japanese currency output and I tried to format the
>column with the Yen sign (ASCII 157) it didn't work.
>Is the format character dependant on the NLS setting? What symbol is
>used in Japan, UK, etc.
>After some years working with Oracle, this is the first time I came across
>this problem.
>Thank you in advance,
>Alex Long

Hie
Oracle has a predefined function called chr(number) . In your case what you would have to do is the following
select chr(157)||yen from foo;
chr(157) will convert the ascii to number and you will get yen.

A yen for yen wont get you a yen :)
Mahesh Vallampati

Home:				   Office:
PH : 409 846 3794 (H)		|  409 862 1070 (O)
e-mail address  : vallampa_at_ee.tamu.edu
WWW 		: http://tam2000.tamu.edu/~m0v5533/
Lab 		: 409 847 8609 

// In the Beginning there was Codd .... Received on Wed May 24 1995 - 00:00:00 CEST