Re: simple Oracle question

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 16 Oct 2000 22:02:06 GMT
Message-ID: <8sftso$7qp$1@nnrp1.deja.com>

In article <8sfmba$pn$1_at_nnrp1.deja.com>, volk333_at_my-deja.com wrote:
> hi ,i have a simple question:
> NUMBER column length default in Oracle8 and Oracle8i
> is 9 or 38? and how can i check it?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

It's 38. You can check it using describe <table_name> command in sqlplus or selecting data_length column from view all_tab_columns.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 17:02:06 CDT