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 left inner join?
What packages(if any) has oracle provided for use by developers?
What does data normalization mean?
what are the different functions in sorting an array? : Sql dba
Is left join and outer join same?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is the command used to fetch first 5 characters of the string? : Sql dba
what are sequences
What is the difference between jpql and sql?
what is the difference between join and union? : Sql dba
What are the topics in pl sql?
Can I create table without primary key?
how to install mysql? : Sql dba
What's the difference between a primary key and a clustered index?
What is sql clause?