Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 21093 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
When is the explicit cursor used ?
What does cursor do in sql?
Explain the working of primary key?
Does truncate remove indexes?
How to Declare Fixed Length String Value In PL SQL
What problem one might face while writing log information to a data-base table in pl/sql?
Show the cursor attributes of pl/sql.
How to run sql*plus commands in sql developer?
What is meant by cursor in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is time a data type in sql?
What is not in sql?
Are null values same as that of zero or a blank space?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What does count (*) mean in sql?
