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

When do I need to use a semicolon vs a slash in oracle sql?

1025


How to create an oracle database?

975


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2242


Which is better Oracle or MS SQL? Why?

4818


Respected sir, Please send me technical questions related to oracle apps..

1758


Explain oracle left join with an example?

951


Explain the use of grant option in imp command.

955


What happens in oracle commit?

969


How do I spool to a csv formatted file using sqlplus?

963


various types of hints and their usage

2622


What is primefaces used for?

1004


What happens if you lost a data file?

976


How to declare a local variable?

1046


How to display employee records who gets more salary than the average salary in the department?

998


How to convert character types to numeric types?

1053