Updating table using cursor in oracle


11-Dec-2017 23:08

When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.

updating table using cursor in oracle-73

dating service in fl

In this chapter, we will discuss the cursors in PL/SQL. A cursor holds the rows (one or more) returned by a SQL statement.Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row.When you fetch a row the current row position moves to next row.If none of the employee’s salary are updated we get a message 'None of the salaries where updated'.

Else we get a message like for example, 'Salaries for 1000 employees are updated' if there are 1000 rows in ‘employee’ table.If this is something you need to do all the time, I would suggest something else, but for a one-off or very small tables it should be sufficient.



Please move to a room where nobody else is present, because you're going to need a moment to yourself after seeing these superhot guys with beards.… continue reading »


Read more

Asian Date is 100% free Asian service to help single women and men, guys or ladies in Asia or in the West find online love and relationship.… continue reading »


Read more

The breast evolved from the sweat gland to produce milk, a nutritious secretion that is the most distinctive characteristic of mammals, along with live birth.… continue reading »


Read more