Re: List of Tables on a database

Hassen AHLAMINE <cainmaro_at_hotmail.com> wrote: > I'm looking for a way to gather:
> - A list of all tables created in a database since the database's name,

connect to the database, then use

SELECT TABLE_NAME FROM ALL_TABLES
> - A list of all columns since the table's name,

SELECT COLUMN_NAME,DATA_TYPE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=.... or in SQL*Plus

DESCRIBE <table_name>

See the documentation of Oracle.

Davide Received on Thu Jan 03 2002 - 02:47:38 CST