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 are different types of keys in sql?
What is sql resultset?
What is the usage of sql functions?
Is delete faster than truncate?
can a stored procedure call itself or recursive stored procedure? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is pl sql record in oracle?
How can I delete duplicate rows?
What is varchar used for?
How do you run a query?
What is difference between inner join and cross join?
What is the difference between delete and truncate commands?
What is pragma in sql?
What does rownum mean in sql?
Can we have two clustered index on a table?