Answer / abc

Select * from user_sys_privs;

Differentiate between function and procedure in oracle.

0 Answers  

---

What are the ansi data types supported in oracle?

0 Answers  

---

Differnce between view and index

3 Answers  

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  

---

What do you understand by database schema and what does it hold?

0 Answers  

---

---

How to turn on or off recycle bin for the instance?

0 Answers  

---

What is cursor

4 Answers   TCS,

---

What are the extensions used by oracle reports?

0 Answers  

---

Difference between the “verify” and “feedback” command?

0 Answers  

---

Explain oracle 12c new features for developers?

0 Answers  

---

How to create a server parameter file?

0 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,

---