Updating the records in to the cursor

Rated 3.85/5 based on 773 customer reviews

This is a complete book on PL/SQL with everything you need to know to write efficient and complex PL/SQL code.When processing a CURSOR, DB2 SQL give option to update or delete data in base table based on current position of CURSOR in result table.

My example: I've two tables, one is main table which will have thousands of records and another is the report table which will have around 6000 records. Hi Tom , I need to write a query which will give me a list of dates between two date ranges (start date and end date) .a sql code to remove all the special characters from a particular column of a table example :i NPUT-ABC -D. FOUTPUT ABC DEFAND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTDONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS.... Hi Tom, I'm sorry, I am working on so much topics, that I don't have time to search.Hi Tom, Great to visit ask tom site i'm keep on learning oracle things here. i have loaded with "SRC_key = 16" new source data into tables which we used in this view. Short question: If I delete cca 3M entries from table of cca 6.5 rows (and 19 columns), would it be beneficial to re-index? Hello, I want to use TDE tablespace encryption on my database.This clause can also be extended to lock only the intended table in the SELECT query containing more than one table in joins using the FOR UPDATE OF clause.This clause becomes meaningless if we use a single table SELECT clause as the minimum Oracle has provided us with the WHERE CURRENT OF clause for both DELETE and UPDATE statements inside a cursor’s range to make changes to the last fetched row(s) from the cursor with an ease.

Leave a Reply