Answer / kumar

https://etltechsolutions.wordpress.com/2017/04/26/easy-way-to-convert-tableau-if-elseif-statements-to-netezza-case-statements/

How do I remove duplicates in two columns?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

What is pls integer?

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

What are pl/sql cursors?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

How the execution will be done in exceptions?

2 Answers  

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

what is data control language? : Sql dba

0 Answers  

---