Re: BUG in DESCRIBE ?
From: Bruce Pihlamae <pihlab_at_cbr.hhcs.gov.au>
Date: 11 Aug 94 13:40:15 +1000
Message-ID: <1994Aug11.134015.1_at_cbr.hhcs.gov.au>
Date: 11 Aug 94 13:40:15 +1000
Message-ID: <1994Aug11.134015.1_at_cbr.hhcs.gov.au>
In article <CJONES.94Aug3130518_at_hurrah.au.oracle.com>, cjones_at_au.oracle.com (Christopher Jones) writes:
>
> Well, it looks like it. From the SQL> prompt I guess you're using
> SQL*Plus. What version is it? I couldn't reproduce the situation
> with SQL*Plus 3.1.2.3 against 7.0.15.4.
>
> SQL> create table test as select * from dual;
>
> Table created.
>
> SQL> desc test
> Name Null? Type
> ------------------------------- -------- ----
> DUMMY VARCHAR2(1)
It appears that the version of SQL*Plus that comes with V7.0.13.0 of
Oracle has this 'bug' but later versions don't.
-- Bruce... pihlab_at_cbr.hhcs.gov.au ******************************************************************* * Bruce Pihlamae -- Database Administration * * Commonwealth Department of Human Services and Health * * Canberra, ACT, Australia (W) 06-289-7056 * *=================================================================* * These are my own thoughts and opinions, few that I have. * ******************************************************************* "The more complex the argument gets, the easier it is to refute." "Killing is wrong!" -- Trent 'The Uncatchable' CastanaverasReceived on Thu Aug 11 1994 - 05:40:15 CEST