Answer Posted / a.jyothsna

Difference between cursor and ref-cursors is same as the
difference between variable and constant.
With ref-cursors we can use the cursors variable.

What are inbuilt functions in sql?

1109

---

what is the difference between delete and truncate commands? : Sql dba

1119

---

What are different joins used in sql?

1107

---

How can a function retun more than one value in oracle with proper example?

1129

---

What are the set operators in sql?

1138

---

What is primary key and unique key?

1167

---

What are the query optimization techniques?

1000

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

1126

---

What is the trigger in sql?

1004

---

What are the different types of dbms?

1067

---

How do I install microsoft sql?

1116

---

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

1632

---

Which operator is used in query for pattern matching?

1133

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1164

---

Is sql better than access?

1070

---