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 we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1950


How to drop a tablespace?

998


What is transport network substrate (tns) in oracle?

1001


Can we create trigger on materialized view in oracle?

946


What are the different types of modules in oracle forms?

961


Explain a private synonyms?

991


What is the purpose of tables, private synonyms and public synonyms in Oracle?

995


Compare and contrast between sql and sql server and explain its various functions?

927


What do you mean by redo log file mirroring?

983


How to pass a cursor variable to a procedure?

1054


What privilege is needed for a user to delete rows from tables in another schema?

1028


What do you mean by cdb and pdb in oracle 12c?

1014


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

983


Explain constraining triggers.

1050


Why is oracle database so popular?

951