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.

Do stored procedures prevent sql injection?

0 Answers  

---

What version is sql?

0 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

What are the different sql languages?

0 Answers  

---

what is a join? : Sql dba

0 Answers  

---

What is execute immediate?

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

what is datawarehouse? : Sql dba

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

what is the boundary line in varrays?

1 Answers   HCL,

---