Answer / gudekotas

SELECT STATEMENT CONTAINS PARTICULAR STRUCTURE AND SELECT
QUERY RESULT SET CONTAINS ROWID,ROWNUM.

CURSOR DOESN'T CONTAIN STRUCTURE AND IT IS
VIRTUAL(CONTEXAREA)MEANS NO ROWID,NO ROWNUM.

Answer / bolearner

The above answer is not so correct.

cursor can fetch rowid, rownum also from table.

The select into cant retrieve more than 1 record in plsql.

But cursor can retrieve more records that can be viewed for modified later in plsql.

Cursors has attributes like open,close,fetch,notfound. Those attributes not applicable in select..into clause.

finally select..into in plsql, just select column values and storing into plsql variable.

Answer / akash

Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.

Which version of sql do I have?

0 Answers  

---

How to find last day of the month in sql query

4 Answers  

---

What is a trigger in sql?

0 Answers  

---

Why is normalization important?

0 Answers  

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

How do I access sql anywhere database?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

What is query syntax?

0 Answers  

---