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
How does postgresql compare to "nosql"?
Why do we use cursors?
What is Materialized View? In What Scenario we Use Materialized View?
What is the difference between in and between in sql?
What is a unique key?
What is function and procedure in pl sql?
Explain the select statement in sql?
Can we alter stored procedure?
Why do we use joins?
How do I remove all records from a table?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is a rank in sql?
What is the use of desc in sql?
How many sql are there?
What do you understand by case manipulation functions?