Answer Posted / harikiran
select ora_database_name from dual
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to drop an index?
How to display employee records who gets more salary than the average salary in the department?
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.
How oracle handles dead locks?
What is partitioned table in Oracle?
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'));
How will you differentiate between varchar & varchar2?
What are the uses of linked server and explain it in detail?
Explain the difference between a procedure and a function?
How to experiment a data lock in oracle?
What is oracle rowcount?
Explain the importance of .pll extension in oracle?
What is difference between sid and service name in oracle?
what is the scripts in data base?
What happens if variable names collide with table/column names?