Re: How to get the settings for Oralce database?
From: Donna Parker <dparke_at_acxiom.com>
Date: 3 Oct 2001 12:12:38 -0700
Message-ID: <d3dff5cd.0110031112.4a74d34d_at_posting.google.com>
Date: 3 Oct 2001 12:12:38 -0700
Message-ID: <d3dff5cd.0110031112.4a74d34d_at_posting.google.com>
set numwidth 27
to show all the set commands type
show all
"Raha" <rahamaz_at_yahoo.com> wrote in message news:<3bbad339.0_at_news.tm.net.my>...
> Hi,
> I'm new in using Oracle database a silly question, "Is there any command
> to get the settings in Oracle 8 database?". I have created a table (column
> c1 NUMBER(27.9)) and inserted a record into the table. When I select the
> same record under interactive SQL, I only manage to see 6 decimal points
> behind eventhough it's stored as nine. Is there any setting that control the
> display format of the data type?
>
> Thanks
Received on Wed Oct 03 2001 - 21:12:38 CEST