State the difference between implict and explict cursor's?

Answer Posted / l..l.n.reddy

IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.

EXPLICT CURSOR:- Defined by user. queries returns more
than rows.

Is This Answer Correct ?    16 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view stored procedures?

545


What are different types of statements supported by sql?

610


What are the benefits of triggers?

604


What is rowtype?

571


What type of database is cloud sql?

580






Explain autonomous transaction.

640


What is the use of non clustered index?

530


Explain dml and ddl?

552


How many sql core licenses do I need?

509


What is an intersect?

657


What is a system versioned table?

538


Which is faster truncate or drop?

564


How do I count duplicates in sql?

552


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

606


What is a left join?

513