Answer / 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.!

Answer / amit

Suppose your 2 databases are name as PROD1 and PROD2
1) How can create a table in particular database?
=> First you have to connect to the database where you want
to create table with given login and password.
and then if you have create permission than you can use
following sql
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

2) select * from tab; will show you how many tables,view or
synonyms are there in your schema.

Answer / meher

If you want to list the tables presented in each database
use the below query:

SELECT * FROM DBA_TABLES; or SELECT * FROM USER_TABLES; -->
this will display all the tables of particulara db.

If you use SELECT * FROM TAB; --> this will display all the
tables,views or synonyms of particulara db.

Answer / vishnu

you can also use the database links to get the data from
other database tables. syntax is table_name@db_link.

Answer / priya

login to one database like
sqlplus username@databasename/password

After enter into sql
create table databasename.tablename
and to call select * from databasename.tablename

then to connect to other user

connect dbuser/pwd (not sure of this statement .. It should
be something like this please google it otherwise)

and to list the tables particular to database:
select * from tab; fetch the result from that particular
database which is connected

write a query to delete similar records in same table

13 Answers   TCS,

How to combine two stored procedures in sql?

0 Answers  

How do you create a db file?

0 Answers  

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

how to include numeric values in sql statements? : Sql dba

0 Answers  

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

what is a stored procedure? : Sql dba

0 Answers  

Who is the owner of mysql database?

0 Answers  

Is oracle sql free?

0 Answers