Re: BUG in DESCRIBE ?

In article <1994Aug2.154005.1_at_cbr.hhcs.gov.au> pihlab_at_cbr.hhcs.gov.au (Bruce Pihlamae) writes:

> SQL> create table test as select * from dual;
>
> Table created.
>
> SQL> select * from test;
>
> D
> -
> X
>
> 1 row selected.
>
> SQL> describe test
> SQL>
>
>
> And LOOK ! No definition for the table TEST !
>
> Is this a bug ?

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)

Chris Received on Wed Aug 03 1994 - 05:05:18 CEST