Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)

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 a record in a database?

1103


what tools available for managing mysql server? : Sql dba

1133


how to write date and time literals? : Sql dba

1010


Why use subqueries instead of joins?

1138


how to present a past time in hours, minutes and seconds? : Sql dba

1072


Can we create table in function?

1022


What is difference between table and view?

1139


What is the difference between rollback and rollback to statements?

1102


What is the difference between clustered and non-clustered indexes?

1132


How can a pl sql block be executed?

1004


What is the purpose of cursors in pl/sql?

1204


Which command is used to call a stored procedure?

1055


define sql insert statement ? : Sql dba

1080


What is procedure explain with program?

1068


Explain ttitle and btitle.

1165