Explain the methods used to protect source code of pl/sql.

0 Answers  

---

Which operator is used in query for pattern matching?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

Why use stored procedures?

0 Answers  

---

---

what is normalization? : Sql dba

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

what is sql in mysql? : Sql dba

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---