Re: Number Format Mask
From: Daniel <twinsxu_at_yahoo.com>
Date: 21 Nov 2001 12:36:27 -0800
Message-ID: <e0e46f5b.0111211236.448c3a4c_at_posting.google.com>
Date: 21 Nov 2001 12:36:27 -0800
Message-ID: <e0e46f5b.0111211236.448c3a4c_at_posting.google.com>
gmohata_at_yahoo.com (Girish Mohata) wrote in message news:<42a840c2.0111202330.41e5fd6b_at_posting.google.com>...
> Hi All,
> I am using Oracle 8 on a solaris platform.
> I have an attribute Total_Cost declared as Number(8,2).
> I want to declare another attribute which would have a similar
> datatype but with a format mask of $9,999.99.
> Is this possible while creating the table or am i limited to doing it
> in my Queries using DECODE ??
>
> Regards,
> Girish
I don't think there is a currency datatype. However, you can use TO_CHAR() function, or use COLUMN command of SQL PLUS to change the display of this column. Received on Wed Nov 21 2001 - 21:36:27 CET