Re: Money Data

From: "Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> Newsgroups: comp.databases.oracle.misc
Subject: Re: Money Data
Date: Fri, 28 Nov 2008 10:01:29 -0800 (PST) Organization: http://groups.google.com
Lines: 36
Message-ID: <ce4264b4-750f-459a-a8b7-f4c9eae42eef_at_v4g2000yqa.googlegroups.com> References: <d5d414a8-2dd6-4efc-b8e7-09eb9874e24c_at_x14g2000yqk.googlegroups.com> NNTP-Posting-Host: 217.15.147.190
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1227895289 28952 127.0.0.1 (28 Nov 2008 18:01:29 GMT) X-Complaints-To: groups-abuse_at_google.com NNTP-Posting-Date: Fri, 28 Nov 2008 18:01:29 +0000 (UTC) Complaints-To: groups-abuse_at_google.com
Injection-Info: v4g2000yqa.googlegroups.com; posting-host!7.15.147.190;

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

        Gecko/2008102920 Firefox/3.0.4,gzip(gfe),gzip(gfe) Xref: textnews.cambrium.nl comp.databases.oracle.misc:26833

On Nov 28, 7:17 pm, Laurence <i.l.bre..._at_open.ac.uk> 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

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 Received on Fri Nov 28 2008 - 12:01:29 CST