Updating the record using cursor
If your database supports duplicate records, then it can potentially contain multiple records that share the same key.cursor(dbp, NULL, &cursorp, 0); /* Set up our DBTs */ = search_key; = strlen(search_key) 1; /* * Position the cursor to the first record in the database whose * key and data begin with the correct strings.You can also perform partial matches if your database supports sorted duplicate sets.In all cases, the key and data parameters of these methods are filled with the key and data values of the database record to which the cursor is positioned as a result of the search.*/ ret = cursorp- A record is a duplicate of another record if the two records share the same key.For duplicate records, only the data portion of the record is unique.Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.cursor(my_database, NULL, &cursorp, 0); /* Initialize our DBTs.
Use SQL*Plus and copy and paste what you already tried. Before posting any code, please read Ora FAQ Forum Guide, especially "How to format your post? Make sure that lines of code do not exceed 80 characters when you format. I am modified the code such that it updates only as 'Change' and 'No Change' for records whose value is not equal to 'Initial'. I have updated in the table manually by updating 'Initial' as value for Indicator Column for the very first occurance. "The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.