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)
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
What is a record in a database?
what tools available for managing mysql server? : Sql dba
how to write date and time literals? : Sql dba
Why use subqueries instead of joins?
how to present a past time in hours, minutes and seconds? : Sql dba
Can we create table in function?
What is difference between table and view?
What is the difference between rollback and rollback to statements?
What is the difference between clustered and non-clustered indexes?
How can a pl sql block be executed?
What is the purpose of cursors in pl/sql?
Which command is used to call a stored procedure?
define sql insert statement ? : Sql dba
What is procedure explain with program?
Explain ttitle and btitle.