Answer / kiran r

A Trigger is block of PLSQL Code which is automatically Executed with response to some events (i.e.., DML).

What is constant in pl sql?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

What is the difference between the conventional and direct path loader? : aql loader

0 Answers  

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

scope of exception handling in plsql

4 Answers   Wipro,

---

What is mutating table?

11 Answers   Saama Tech,

---

What is view? Can we update view

0 Answers  

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---