PL/SQL to update multiple rows in one table using data from another table in the same schema
Posted on 2004-08-31
I have two tables in the schema.
The first table, violation_codes, has a section_number and fine, among other columns, but these two are the focus of the problem.
The second table, bond, has an orc and fine, among other columns as well.
For each row in the violation_codes table where the section_number equals the orc in the bond table, I need to update the violation_codes.fine column with the fine amount in the bond table.
I have been playing around with a cursor to accomplish this, but haven't had any luck. Any help would be appreciated.