AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 1 hour 8 min ago

update using bulk collect in plsql with exit when statement ,plsql script to run code in batches of 500 with some update statement

Fri, 02/12/2016 - 00:00
here is a table having 2000 records i need to update the table with some given condition update tablename set counter=1 where counter=null and rownum<500 for first execution so that counter should be 4 at last of 2000 rows execution,EXIT WHEN counter...

pl/sql function accept date of birth as "dd-mm-yyyy" and sum all digits

Fri, 02/05/2016 - 00:00
write a pl/sql function accept date of birth as "dd-mm-yyyy" and sum all digits till you get single digit number to show as he lucky number.

restore + rename database in one step

Wed, 01/27/2016 - 00:00
Hi, We want to 1. restore the database _without_ RMAN (classical shutdown + copy all files) to a new destination 2. rename the database + datafile locations by recreating the controlfile Source Binary Set: Target Binary Set: 11.2.0....

Rebuild Index in parallel after direct load

Fri, 01/22/2016 - 00:00
Hello, we have a table with two partitions PART1 and PART2 (List partitioning) and local indexes on it. Only one partition is filled with data, the other partition is empty. In a nightly batchjob we check if PART1 or PART2 is filled and then l...

Modify Insert statement to avoid Primary Key constraint.

Thu, 01/21/2016 - 00:00
I am dealing with a 3rd party legacy application, in which the code cannot be changed. Periodically, this application inserts rows in a table which causes it to have a Primary key error. I need a way to "stop Oracle" from raising a exception of...

correlational update statement giving performance issue

Fri, 01/15/2016 - 00:00
The below update statement is taking lot of time. Can you please help me to tune this query? I will prefer re-structuring the query rather than using any HINT. My only constraint is, I can?t use index since there is no index in the table UPDATE ta...