Re: How do I list Oracle table names
| From: | Philippe Saladin | Date: | Fri, 08 Nov 2002 07:44:47 +0000 |
| Subject: | Re: How do I list Oracle table names | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23128@lists.php.net to get a copy of this message | ||
<smdief@juno.com> a écrit dans le message news:
20021107.154835.530.124882@webmail1.wlv.untd.com...
> I'm very new at this. Is there a way I can list all table names in an
Oracle database?
I thinl you know how to connect to Oracle via php (simple tutorial :
http://www.thickbook.com/extra/php_oracle.phtml)
To obtain a list of the tables, just execute this query :
select table_name from sys.all_tables
where owner = '<MYOWNER';
Regards,
Philippe