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
Which is faster joins or subqueries?
Write a sql select query that only returns each name only once from a table?
How to pipe multiline string to isql?
write an sql query to find names of employee start with 'a'? : Sql dba
What is materialized view. What are different methods of refresh?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is the difference between execution of triggers and stored procedures?
explain access control lists. : Sql dba
What is procedure function?
What is crud sql?
What is the use of prepared statement?
Is there a 64 bit version of ssms?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is serial sql?
List and explain the different types of join clauses supported in ansi-standard sql?