Oracle equivalent of "mysql_list_tables"

[Anon]

Like the subject says. Does Oracle 8 have an equivalent? Either in PHP or SQL*PLUS - I don't care, I'd just like to see a list of tables in the db. I've done some research, but nothing obvious popped out at me.

Thanks.

[Anon]

select user,table_name from all_tables

I don't know what info mysql_list_tables returns but you can look through the columns in all_tables (desc all_tables) and select whatever you want.

-- mp

[Anon]

It has something similar. You have to be logged in as system or have been granted DBA.

Then do a SELECT * FROM dba_tables;

The rest is up to you...

[Anon]

Scratch my last comment...

My brain is not working right now - I know it is along those lines though

[Anon]

hi,
i am a user of oracle's SQL is it easy for to turn on php,how and why.
and,by the way what is a PHP?
wating for ur repaly
bye

[Anon]

not sure if it will work for you but we use:
select table_name from user_tables;