Knowledge Base.

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

See Password Fields Masked Values.

Tuesday, April 19, 2016

Do you need to see the password in a password fields? Then here is how to See Password Field's Masked Value as a Clear Text
...Click here for more


Special Characters in HTML.

Tuesday, April 19, 2016

Here are all the special characters in HTML. Like if you need to add space or quotation mark and so on
...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


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 (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




© 2017 - DJames.net