Re: Q: What is done when using desc?

> > I am wondering about what sqlplus is doing when I query the database with a
> > DESC TABLE.
maybe something like..??

      SELECT column_name,
            data_type,
            nullable,
            data_length,
            data_precision,
            data_scale,
            default_length,
            data_default
        FROM all_tab_columns
        WHERE table_name = :XYZ;

Mark Stratford Received on Tue Jan 14 2003 - 03:17:04 CST