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

how do get database name at sql prompt?

Answer Posted / harikiran

select ora_database_name from dual

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an index?

959


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

1065


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846


How oracle handles dead locks?

1065


What is partitioned table in Oracle?

1188


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690


How will you differentiate between varchar & varchar2?

1041


What are the uses of linked server and explain it in detail?

1059


Explain the difference between a procedure and a function?

1169


How to experiment a data lock in oracle?

1056


What is oracle rowcount?

1084


Explain the importance of .pll extension in oracle?

1009


What is difference between sid and service name in oracle?

956


what is the scripts in data base?

2153


What happens if variable names collide with table/column names?

1191