Check Tables in Oracle

[PatOls]

How do I check all the tables available in an Oracle database by using sql-statements?

Anyone know?

Thanks for any help

[JazzBass]

Select * from User_Tables

This is decribe on the table:

TABLE_NAME                      NOT NULL VARCHAR2(30)
TABLESPACE_NAME                          VARCHAR2(30)
CLUSTER_NAME                             VARCHAR2(30)
IOT_NAME                                 VARCHAR2(30)
PCT_FREE                                 NUMBER
PCT_USED                                 NUMBER
INI_TRANS                                NUMBER
MAX_TRANS                                NUMBER
INITIAL_EXTENT                           NUMBER
NEXT_EXTENT                              NUMBER
MIN_EXTENTS                              NUMBER
MAX_EXTENTS                              NUMBER
PCT_INCREASE                             NUMBER
FREELISTS                                NUMBER
FREELIST_GROUPS                          NUMBER
LOGGING                                  VARCHAR2(3)
BACKED_UP                                VARCHAR2(1)
NUM_ROWS                                 NUMBER
BLOCKS                                   NUMBER
EMPTY_BLOCKS                             NUMBER
AVG_SPACE                                NUMBER
CHAIN_CNT                                NUMBER
AVG_ROW_LEN                              NUMBER
AVG_SPACE_FREELIST_BLOCKS                NUMBER
NUM_FREELIST_BLOCKS                      NUMBER
DEGREE                                   VARCHAR2(10)
INSTANCES                                VARCHAR2(10)
CACHE                                    VARCHAR2(5)
TABLE_LOCK                               VARCHAR2(8)
SAMPLE_SIZE                              NUMBER
LAST_ANALYZED                            DATE
PARTITIONED                              VARCHAR2(3)
IOT_TYPE                                 VARCHAR2(12)
TEMPORARY                                VARCHAR2(1)
NESTED                                   VARCHAR2(3)
BUFFER_POOL                              VARCHAR2(7)

Hope that helps.

JazzBass