Oracle updating cursor

If you run a SELECT INTO statement in PL/SQL block, the implicit cursor attribute can be used to find out whether any row has been returned by the SELECT statement.It will return an error if there no data is selected.A cursor can hold more than one row, but can process only one row at a time.The set of rows the cursor holds is called the These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed.For instance, I might have the following psuedo code: Excuse my psuedo code off the top of my head.In the above sample, I am selecting a value from TABLEX.Oracle provides few attributes called as implicit cursor attributes to check the status of DML operations.The cursor attributes available are %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.

In this example, we are using the already created CUSTOMERS table.

Both implicit and explicit cursors have the same functionality, but they differ in the way they are accessed.

When you execute DML statements like DELETE, INSERT, UPDATE and SELECT statements, implicit statements are created to process these statements.

These cursors should be defined in the declaration section of the PL/SQL block.

It is created on a SELECT statement which returns more than one row.

Search for oracle updating cursor:

oracle updating cursor-65oracle updating cursor-89

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “oracle updating cursor”

  1. I’m honored to be able to feature you and send you over some new readers. It’s a great place to ask questions on how to make things or for specific tutorials you need.