Re: SQL statement to get all tables in the database

From: Arangaperumal <gaperumal_at_hotmail.com>
Date: 16 Nov 2004 03:35:03 -0800
Message-ID: <5b7fac1d.0411160335.2817d2b6@posting.google.com>

jrefactors_at_hotmail.com (Matt) wrote in message news:<ba8a039e.0411141914.53c314ff_at_posting.google.com>...
> In oracle, any SQL statements to get all tables in the database?
> I am using SQL* PLUS, and I want to see what are all tables in
> the database.
>
> Please advise. Thanks!!

select owner as schemaname, table_name from all_tables where owner NOT IN ('SYS','SYSTEM') Received on Tue Nov 16 2004 - 05:35:03 CST

This message: [ Message body ]
Next message: Alex: "xmltype as parameter to stored procedure"
Previous message: Yasaswi Pulavarti: "multiple databases"
In reply to: Matt: "SQL statement to get all tables in the database"
Next in thread: Harsha: "Re: SQL statement to get all tables in the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US