Hi ,

I'm in the process of migrating a SQLServer database to Oracle. This
is the first Oracle database I've been involved with and I'm aware
that there is no money data type in Oracle. I appreciate that the
columns that need to hold money will need to be number datatypes, and
I notice that number(19,4) seems to crop up frequently in gateway
documents.

My question is, is there any way in which the currency symbol can be
retrieved with the data without needing to alter the SQL that exists
now ? This will need to work irrespective of the type of program that
connects to the database - UNIX/C/COBOL and VB/ASP/.NET. If it's not
possible, how is the SQL altered to achieve this ?

Thanks in advance.

Laurence

"Laurence" <i.l.breeze (AT) open (DOT) ac.uk> wrote

the currency is that you desire. You can set the nls_currency for the
particular connection and request the number be converted to a string
to_char(field, format string) see the docs.
Jim

"Laurence" <i.l.breeze (AT) open (DOT) ac.uk> wrote

the currency is that you desire. You can set the nls_currency for the
particular connection and request the number be converted to a string
to_char(field, format string) see the docs.
Jim

"Laurence" <i.l.breeze (AT) open (DOT) ac.uk> wrote

the currency is that you desire. You can set the nls_currency for the
particular connection and request the number be converted to a string
to_char(field, format string) see the docs.
Jim

"Laurence" <i.l.breeze (AT) open (DOT) ac.uk> wrote

the currency is that you desire. You can set the nls_currency for the
particular connection and request the number be converted to a string
to_char(field, format string) see the docs.
Jim

On Nov 28, 7:17*pm, Laurence <i.l.bre... (AT) open (DOT) ac.uk> wrote:
Afaik, currency symbol is not stored with MONEY datatype, only the
value, so it's a bit unclear how you retrieve it now. Can you post an
example? And, as a side note, SQL Server's currency symbols in
literals support, as in

DECLARE @amount AS MONEY
SET @amount = $100

is not available in Oracle, so if your code uses anything like this,
it will need to be altered to remove currency symbols from such
literals.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On Nov 28, 7:17*pm, Laurence <i.l.bre... (AT) open (DOT) ac.uk> wrote:
Afaik, currency symbol is not stored with MONEY datatype, only the
value, so it's a bit unclear how you retrieve it now. Can you post an
example? And, as a side note, SQL Server's currency symbols in
literals support, as in

DECLARE @amount AS MONEY
SET @amount = $100

is not available in Oracle, so if your code uses anything like this,
it will need to be altered to remove currency symbols from such
literals.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On Nov 28, 7:17*pm, Laurence <i.l.bre... (AT) open (DOT) ac.uk> wrote:
Afaik, currency symbol is not stored with MONEY datatype, only the
value, so it's a bit unclear how you retrieve it now. Can you post an
example? And, as a side note, SQL Server's currency symbols in
literals support, as in

DECLARE @amount AS MONEY
SET @amount = $100

is not available in Oracle, so if your code uses anything like this,
it will need to be altered to remove currency symbols from such
literals.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On Nov 28, 7:17*pm, Laurence <i.l.bre... (AT) open (DOT) ac.uk> wrote:
Afaik, currency symbol is not stored with MONEY datatype, only the
value, so it's a bit unclear how you retrieve it now. Can you post an
example? And, as a side note, SQL Server's currency symbols in
literals support, as in

DECLARE @amount AS MONEY
SET @amount = $100

is not available in Oracle, so if your code uses anything like this,
it will need to be altered to remove currency symbols from such
literals.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On Nov 28, 11:34*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
I agree with Jim. The specific document in question that explains the
to_char function and format masks is the SQL manual.

http://download.oracle.com/docs/cd/B...htm#SQLRF06130

HTH -- Mark D Powell --