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 are the data types allowed in a table?

3 Answers  

---

What is the use of <> sql?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

---

What are the types of join and explain each?

0 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

How do you bind variables in pl sql?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

What is a sql profiler?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---