Plsql updating in cursor anne curtis dating now


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 set.When you fetch a row the current row position moves to next row.The SELECT FOR UPDATE statement allows you to lock the records in the cursor result set.

plsql updating in cursor-7plsql updating in cursor-58plsql updating in cursor-63plsql updating in cursor-39

” In the print version of the article, only choice a was correct.Part 12 in a series of articles on understanding and using PL/SQL The central purpose of the Oracle PL/SQL language is to make it as easy and efficient as possible to query and change the contents of tables in a database.You must, of course, use the SQL language to access tables, and each time you do so, you use a to get the job done.This article focuses on the most-common ways programmers execute SELECT statements in PL/SQL, namely At the end of the article, I offer some quick tips to help you figure out which of these techniques you should use for different scenarios.SELECT-INTO offers the fastest and simplest way to fetch a single row from a SELECT statement.Hi everyone, still playing around with newbie stuff here.

You must have an account to comment. Please register or login here!