Re: How to examine Oracle db?

Hallo Karsten , to examine an Oracle DB you have to know one table, that is ALL_OBJECTS . Do a select on that table you find all the objects in an instance, meaning tables, views, synonyms, storeds etc. You will find all tables and views beginning with ALL... there. E.g. the view ALL_TAB_COLUMNS will show you you all the attributes of all tables. If you do not want to look on ALL objects of all users in the db, you have the same views beginning with USER... So you will find all tables belonging to the user (better scheme)you are logged in when doing a select on USER_TABLES. Finding stored procedures is easy when you look in ALL_OBJECTS or USER_OBJECTS with the OBJECT_TYPE set to "PACKAGE%" , "FUNCTION" or "PROCEDURE". Hope that helps. Regards, Ralf > 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) > > In MySQL I would use explain, show tables, etc. But how to do it in > Oracle? > > Thanks, > Karsten > -- > ----------------------------- > Why do we have to hide from the police, daddy? > Because we use emacs, son. They use vi. > ----------------------------- > mailto:k.dambekalns@tu-bs.de w³: > http://www.k-fish.de/ > ----------------------------- > Medienwissenschaftler in BS: > http://www.tu-bs.de/institute/mewi/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- Sent through GMX FreeMail - http://www.gmx.net