Answer / neha sinha

It is not possible to create standalone SP with same name.
But it is possible if we will create multiple SP with same
name and different parameter in a package (overloading).

Answer / nrapendra

function overloadding is allowed in pl sql .we can creete
multiple sp of same name but paramerter should be different.

What is nosql vs 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  

---

Is coalesce faster than isnull?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

---

What is pl sql block structure?

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

What is nested table in pl sql?

0 Answers  

---