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 are different types of keys in sql?

1067


What is sql resultset?

934


What is the usage of sql functions?

1079


Is delete faster than truncate?

960


can a stored procedure call itself or recursive stored procedure? : Sql dba

960


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1087


What is pl sql record in oracle?

971


How can I delete duplicate rows?

966


What is varchar used for?

1025


How do you run a query?

958


What is difference between inner join and cross join?

912


What is the difference between delete and truncate commands?

978


What is pragma in sql?

1023


What does rownum mean in sql?

953


Can we have two clustered index on a table?

968