Answer Posted / naresh bs

The main difference is that, a procedure may return and
value but a function has to return a value.

Can we use delete in merge statement?

1039

---

What is the difference between a database and a relational database?

1103

---

What is clustered index sql?

984

---

What are the syntax and use of the coalesce function?

1202

---

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

1580

---

What does an inner join do?

1179

---

How do I edit a trigger in sql developer?

993

---

Explian rowid, rownum?

1012

---

how to fetch common records from two tables? : Sql dba

1172

---

What is the purpose of cursors in pl/sql?

1134

---

What is percent sign in sql?

1283

---

What is lookup table in sql?

1045

---

Explain what is rdbms?

1032

---

what is a join? : Sql dba

1034

---

How to change the order of columns in Oracle SQL Plus ?

1058

---