Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 5 Answers
- 9583 Views
- Relq, I also Faced
- E-Mail Answers
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 to connect a sql*plus session to an oracle server?
Is primary key an index?
What is synonyms?
how to get a list of columns in an existing table? : Sql dba
Does user triggers have entry for trigger with compilation errors?
How to check if a column is nullable before setting to nullable?
What is left join in sql?
what are aggregate and scalar functions? : Sql dba
Why do we use triggers?
How do you update a value in sql?
What are tables and fields in the database?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is index example?
What is the difference among union, minus and intersect?
how to use regular expression in pattern match conditions? : Sql dba
