suppose you have two databases: db1 and db2 you have to select one of them

I have 2 Databases. How can create a table in particular
database? How can i know the list of tables presented each
database?( in oracle 10g)

Question Posted / neeraj sinha

5 Answers
9560 Views
Relq, I also Faced
E-Mail Answers

Answer Posted / neeraj sinha

suppose you have two databases: db1 and db2
you have to select one of them
as
sql>use db1;
then use
sql>select * from tab;
it will show you the listing required.!

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is right join in sql?

1083

What do you understand by exception handling in pl/sql?

1026

What is schema in sql?

941

Is sql a dbms?

992

Does sql profiler affect performance?

987

What is nosql vs sql?

1172

What is the use of function "module procedure" in pl/sql?

1189

Can we call a function containing dml statements in a select query?

966

How do I copy a table in sql?

975

what are the t string functions available in tsql? : Transact sql

1001

What is mutating error in pl sql?

1012

What are the different types of a subquery?

1044

What is loop in pl sql?

1032

What is the difference among union, minus and intersect?

989

How many databases can sql express handle?

976