SELECT STATEMENT CONTAINS PARTICULAR STRUCTURE AND SELECT QUERY RESULT SE

What is difference between select statement and cursor

Question Posted / gudekotas

3 Answers
21102 Views
JDA, I also Faced
E-Mail Answers

Answer Posted / 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.

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a nested table in word?

957

What is the maximum size of sqlite database?

1111

How is indexing done in search engines?

982

how to convert numeric values to character strings? : Sql dba

1107

State some properties of relational databases?

1056

Which table is left in join?

978

What is the difference between function and procedure in pl/sql?

1084

Can ddl statements be used in pl/sql?

1143

How to get each name only once from an employee table?

1116

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1001

Explain architecture of sql server notification services?

1060

What are pl/sql cursors?

1049

What are pl sql data types?

1009

What is the current version of sql?

1023

What are the main features of cursor?

1071