SELECT * FROM user_tables; will give you the list of tables and properties. I think the table name's columns is called: 'table_name' so this should be: SELECT table_name FROM user_tables; -- Maxim Maletsky maxim@php.net smdief@juno.com wrote... : > I'm very new at this. Can I list all the table names in an Oracle database? > > > > > ________________________________________________________________ > Sign Up for Juno Platinum Internet Access Today > Only $9.95 per month! > Visit www.juno.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
