Re: SQL and Oracle

If you don't have access to the dba_xxx tables, use all_tables.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

kmidkiff <kmidkiff_at_home.com> wrote in message news:387C2674.D4A656F2_at_home.com...
> Use dba_tables
> SQL> desc dba_tables
> Name Null? Type
> ------------------------------- -------- ----
> OWNER NOT NULL VARCHAR2(30)
> TABLE_NAME NOT NULL VARCHAR2(30)
> TABLESPACE_NAME NOT NULL VARCHAR2(30)
> CLUSTER_NAME VARCHAR2(30)
> PCT_FREE NUMBER
> PCT_USED NOT NULL NUMBER
> INI_TRANS NOT NULL NUMBER
> MAX_TRANS NOT NULL NUMBER
> INITIAL_EXTENT NUMBER
> NEXT_EXTENT NUMBER
> MIN_EXTENTS NUMBER
> MAX_EXTENTS NUMBER
> PCT_INCREASE NUMBER
> FREELISTS NUMBER
> FREELIST_GROUPS NUMBER
> BACKED_UP VARCHAR2(1)
> NUM_ROWS NUMBER
> BLOCKS NUMBER
> EMPTY_BLOCKS NUMBER
> AVG_SPACE NUMBER
> CHAIN_CNT NUMBER
> AVG_ROW_LEN NUMBER
> DEGREE VARCHAR2(10)
> INSTANCES VARCHAR2(10)
> CACHE VARCHAR2(5)
> TABLE_LOCK VARCHAR2(8)
>
> This will provide owner and num_rows (valid after any analyze - estimate
or
> compute) to provide information for your query.
>
>
> Pavan wrote:
>
> > How can I list all the tables in a Users Schema, which does contain any
> > records in them using a single SQL Query or a Statement.
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> > The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Jan 12 2000 - 10:59:38 CST