Re: How to examine Oracle db?
| From: | Andreas Karajannis | Date: | Fri, 10 Nov 2000 08:20:30 +0000 |
| Subject: | Re: How to examine Oracle db? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4354@lists.php.net to get a copy of this message | ||
Karsten Dambekalns wrote:
>
> Hi!
>
> I have to rewrite a system from java to php. Because there is lots of data,
> I have to use the existing Oracle db. Since I have never worked with Oracle
> before, I don't know how to find out the necessary information about the
> database setup.
>
> I need to know:
> - the names of all the tables in the database
> - the names and types of all the fields in the tables
> - the stored procedures (if any)
>
Take a look at www.oracletool.com - "A web based data dictionary browser
for Oracle DBA's". It's a Perl CGI script similar to MySQLAdmin.
-Andreas
--
Andreas Karajannis
GMD National Research Center for Information Technology
Schloss Birlinghoven, D-53754 Sankt Augustin
Phone +49 2241 142948