Re: Money Data

From: Vladimir M. Zakharychev <>
Date: Fri, 28 Nov 2008 10:01:29 -0800 (PST)
Message-ID: <>

From: "Vladimir M. Zakharychev" <> Newsgroups:
Subject: Re: Money Data
Date: Fri, 28 Nov 2008 10:01:29 -0800 (PST) Organization:
Lines: 36
Message-ID: <> References: <> NNTP-Posting-Host:
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: 1227895289 28952 (28 Nov 2008 18:01:29 GMT) X-Complaints-To: NNTP-Posting-Date: Fri, 28 Nov 2008 18:01:29 +0000 (UTC) Complaints-To:
Injection-Info:; posting-host!;

        posting-account=PAnILQoAAAD84SMI2vqfU32t6U_KSuGX User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:

        Gecko/2008102920 Firefox/3.0.4,gzip(gfe),gzip(gfe) Xref:

On Nov 28, 7:17 pm, Laurence <> wrote:
> 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

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

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.


   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm) Received on Fri Nov 28 2008 - 12:01:29 CST

Original text of this message