How to get the settings for Oralce database?
From: Raha <rahamaz_at_yahoo.com>
Date: Wed, 3 Oct 2001 16:56:39 +0800
Message-ID: <3bbad339.0_at_news.tm.net.my>
Date: Wed, 3 Oct 2001 16:56:39 +0800
Message-ID: <3bbad339.0_at_news.tm.net.my>
Hi,
Thanks
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?