Re: varchar2(0)?

From: Eugenio <Eugenio.Spadafora_at_Compaq.Com>
Date: 2000/07/25
Message-ID: <8ljsqt$cm1$1@mailint03.im.hou.compaq.com>#1/1

it's an error.

do

DESC all_all_tables

SQL> create table t(n varchar(0));
create table t(n varchar(0))

                          *

ERROR at line 1:
ORA-01723: zero-length columns are not allowed

--
Ciao

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Michael Zwiers wrote in message ...


>Michael Zwiers <MRZwiers_at_usa.net> wrote:

>

>> What is the use of varchar2(0)?

>

>Appearantly it cannot be created, but the Oracle documentation show

>this for ALL_ALL_TABLES:

>

>TABLE_TYPE_OWNER   VARCHAR2(0)   Owner of the type of the table if the

>table is a typed table

>

>TABLE_TYPE   VARCHAR2(0)   Type of the table if the table is a typed

>table

>

>PACKED   VARCHAR2(0)   If the table is a typed table, does it store

>objects in packed format?

>

>Is this a typo of somekind?

>

>Michael Zwiers

Received on Tue Jul 25 2000 - 00:00:00 CDT