Number Format Mask
From: Girish Mohata <gmohata_at_yahoo.com>
Date: 20 Nov 2001 23:30:01 -0800
Message-ID: <42a840c2.0111202330.41e5fd6b_at_posting.google.com>
Date: 20 Nov 2001 23:30:01 -0800
Message-ID: <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
Received on Wed Nov 21 2001 - 08:30:01 CET