Is a rollback possible to any savepoint?

0 Answers  

---

What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers  

---

Why does for update in oracle 8 cause an ora-01002 error?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

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'));

0 Answers   IBM,

---

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

What is Data Block ?

2 Answers  

---

What are data pump export and import modes?

0 Answers  

---

What are the various oracle database objects?

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

What is a database table in oracle?

0 Answers  

---