What is a cursor for loop ?

Answer Posted / suresh somayajula

Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you sum a count in sql?

757


how to add a new column to an existing table in mysql? : Sql dba

798


What is exception? What are the types of exceptions?

814


How much does a sql dba make? : SQL DBA

696


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

846


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

864


what are the performance and scalability characteristics of mysql? : Sql dba

749


How does left join work in sql?

727


Explian rowid, rownum? What are the psoducolumns we have?

778


Is sql a case sensitive language?

732


How many parts of a pl sql block are optional?

741


How to display Row Number with Records in Oracle SQL Plus?

791


what is sql in mysql? : Sql dba

855


what is a database transaction? : Sql dba

849


How does a covering index work?

702