Knowledge Base.

Here I will share my experiences on any other subjects on computer technologies, on life, on anything!...

Running Bulk Updates Faster using DML Merge.

Friday, February 12, 2016

Currently I have been having problem with running Update on a big scale tables. It runs awfully terribly slow. Once tried creating a new table with the updated information, and then truncating table and inserting the data from the new table but it is a hastle. I know there must be a way. Finally I found this site ( where he tested all the possible solutions. Without going any detail, here is the best solution to update a large scale table with WHERE condition.
...Click here for more

Handling Ampersand on Oracle SQL.

Thursday, December 10, 2015

While working on Oracle SQL statements, if you have text fields containing ampersand / and (&) symbol, you will probably get a pop-up for input screen asking for variables. It is because ampersand works as a variable on the query. What you need to do is:
...Click here for more

© 2024 -