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


Please Help Members By Posting Answers For Below Questions

What is nvarchar in sql?

711


Do we need to rebuild index after truncate?

698


How you improve the performance of sql*loader? : aql loader

748


How do you copy a table in sql?

748


what is sp_pkeys? : Transact sql

887






What is scalar function in sql?

704


What is set serveroutput on?

841


what is the syntax used for partition in tsql? : Transact sql

727


What is sql deadlock?

741


How to disable a trigger name update_salary?

892


what is meant by urlencode and urldocode? : Sql dba

768


What is a record in pl/sql?

763


Is sql a microsoft product?

690


What are the two types of exceptions in pl/sql?

731


How do I tune a sql query?

723