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...

sql command 2 know current database

Answer Posted / madhu sekhar

You want to know the What is the Data Base version you are
using you can go like this

1) show version (In sql*Plus)
2) Select * from v$version;(In Toad or PL/SQL Developer)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create additional tablespaces for an new database?

1026


Explain the use of log option in exp command.

1119


How to rollback the current transaction in oracle?

1054


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353


How to define and use table alias names in oracle?

941


What is a lookup table in oracle?

973


How to commit the current transaction in oracle?

1118


How to connect to the server with user account: sys?

1017


What is data file?

1103


Explain view?

1030


What is the difference between Delete, Truncate and Drop in Oracle?

1129


What is an oracle recycle bin?

1009


Explain overloading. Can functions be overloaded?

986


6. Display the client name and order date for all orders using the traditional method.

2305


How to join two tables in a single query using oracle?

995