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 (http://www.orafaq.com/node/2450) 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

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