What is difference between select statement and cursor
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
Can we perform dml in function?
What is delimiter in pl sql?
What is a data definition language?
What are triggers in sql?
What is difference between stored procedures and application procedures?
What has stored procedures in sql and how we can use it?
What are the benefits of triggers?
What is a system versioned table?
Can we use the cursor's to create the collection in PL/SQL?
What is a heap in sql?
What are pl/sql cursors?
Do we need to create index on primary key?
What is a database? Explain
how to enter numeric values as hex numbers? : Sql dba
Does sql backup shrink transaction log?