Answer Posted / hitendra yadav

We can return multiple records from procedure through
using reference cursor variable as out parameter of
procedure.

What's the procedure?

981

---

What is %rowtype in pl sql?

1026

---

what is index? : Sql dba

1040

---

How to pronounce postgresql?

1092

---

What is meant by cursor in sql?

1058

---

What is the difference between Union and Union all. Which is faster.

1436

---

What are the rules to be applied to nulls whilst doing comparisons?

1363

---

Can a foreign key have a different name?

992

---

What is t sql in sql server?

1129

---

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

1626

---

How do I edit a stored procedure?

1045

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1272

---

define sql insert statement ? : Sql dba

1077

---

What are expressions?

1059

---

Can we debug stored procedure?

1062

---