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.

what is a trigger in mysql? : Sql dba

0 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

How many postgresql users are there, worldwide?

0 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

define primary key & secondary key?

2 Answers  

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

What are secondary keys?

0 Answers  

---

What is embedded sql with example?

0 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---