How to examine Oracle db?

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/