Re: Oracle objects
| From: | omar cromwell mercado | Date: | Sat, 11 Nov 2000 10:05:39 +0000 |
| Subject: | Re: Oracle objects | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4369@lists.php.net to get a copy of this message | ||
Hi,
To display tables in oracle, do:
select object_name from all_objects where
object_type='TABLE' and owner='<DATABASE_NAME>';
To show fields and type of a table, do:
desc <TABLE_NAME>;
hope this helps.
omar
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/