Use a specific database & find it's tables.

[zensunni]

In MySQL, I would just go:

"use <database name>;"

Is there an equivalent in Oracle? Also, how would I list all the tables in my database?

Thanks.

[debasisdas]

In oracle to use any database you need to connect to that first. and to connect you need to pass user name,password and the name of the database.

and to select the tables query DBA_TABLES.

TRY USING THIS

select owner,count(table_name) from dba_tables group by owner;

[QVeen72]

Hi,

Try any of these:

Select * From Tab Where TabType='TABLE'
 
SELECT * FROM user_tables
 
SELECT * FROM dba_tables
WHERE owner = 'MY_SCHEMA_NAME'
 
 

Regards
Veena

[zensunni]

I should have just tested the create table command, but I was just so used to MySQL where you have to select your database first. I feel kind of slow now.

Anyways, thanks for the commands! :)