Re: How to list Oracle table names
| From: | Maxim Maletsky | Date: | Fri, 08 Nov 2002 14:50:28 +0000 |
| Subject: | Re: How to list Oracle table names | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23137@lists.php.net to get a copy of this message | ||
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
>