Answer Posted / polisetti v v satyanarayana

Actually there is difference between function and procedure
i.e procedure is a function but it will never return any
value but where as function will return the value and
overloading means using the using the same function name
with difference in number of parameters to have more
flexibility .For overloading functions compiler will us the
technique called name mangling

What is varchar used for?

1074

---

How does left join work in sql?

995

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1578

---

What is cte sql?

979

---

What are stuff and replace function?

1071

---

Is primary key a clustered index?

963

---

What is java sql driver?

1106

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1215

---

What is difference between sql and excel?

1080

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1052

---

How do you optimize a stored procedure in sql?

941

---

What does fetching a cursor do?

1077

---

What is a constraint? Tell me about its various levels.

1151

---

Is record in pl sql?

959

---

Can we use delete in merge statement?

1033

---