Re: HELP:How to get list of tables in a database in Oracle?
From: Michael Rife <mrife_at_nyx.cs.du.edu>
Date: 10 Jul 1994 05:25:59 -0600
Message-ID: <2vols7$bbi_at_nyx.cs.du.edu>
Date: 10 Jul 1994 05:25:59 -0600
Message-ID: <2vols7$bbi_at_nyx.cs.du.edu>
Login into Oracle with an account that has DBA privileges and do a "SELECT * FROM DBA_TABLES;". This will give you a list of all the tables in the database. Select from USER_TABLES for only the table the user owns. Received on Sun Jul 10 1994 - 13:25:59 CEST