Updating tables within cursor loop

Oracle has continued to improve and extend the possibilities for bulk PL/SQL processing through its 9i releases One and Two. It is assumed that readers are familiar with the bulk PL/SQL fetching and binding constructs available in Oracle 8i (i.e. If you require some background, follow the link to my 8i-specific article above.

These composite variables have internal components that you can treat as individual variables.

I have two tables, one with a list of cities( we'll call this City List), and another with data points that correspond with those cities ( Call this The Data Table). I went ahead and ran this as a little test (admittedly my initial post was not fully tested -- only for syntax), and it works.

The Data Table, is connected to a Select query that I built in MS SQL Server. I can't help but think there is a simple [email protected] unfortunately, I'm not sure I should do that.

They only operate on one row at a time so to access the data returned by the database we must Move the cursor Next or Previous, First or Last.

Please download Looping Through A Recordset Recordsets have two important properties when looping through data, EOF (End-Of-File) and BOF (Beginning-Of-File).

as i mentioned in code to insert into changed_comm , to be done in single procedure only.

Please help me on this Sorry i just edited , now there is only deptno 20, but how to insert if many comm= null gets updated..

'For the purposes of this post, we are simply going to make 'str SQL equal to tbl Teachers.