How To’s, Tech Software, Utilities, Tutorials, Gadgets

Several weeks ago, I got something special to do. I had to add database name in tnsnames.ora for all workstation in my laboratory. Do you know how many computer in my lab? Seventy-five!!! Although can be done over PDC (Public Domain Controller) and helped by some friends, it’s still very hard to do. Because I’ve to check it one by one. Actually, there are some sql editor we can use. One of them is SQL Developer. If we use this editor, we no need to set tnsnames.ora file. Just simply type the server IP address and the database name before we log in. This is the screenshot: Knowledge to Share (http://studiawan.blogspot.com/2007/06/sql-developer-sql-editor-alternative.html)