Oracle SQL Developer
I needed to access some data on our corporate Oracle database server. Unfortunately, no information was given to me other that the PHP connection string. I had not idea about the table or view names either, so I tried to use a database management tool but lacking any previous knowledge about Oracle databases I look for what I've used in the past. I was quite happy with EMS Postgresql Manager and I learned they do have a simlilar product for Oracle databases, but after installing it I learned I needed to install SQL*Net software which I did not know where to get from. However, a quick Google search lead me to another gem from Oracle: SQL developer and the word free captured my attention inmediately. It turns out it is a nice Java program that is available for a variety of platforms. I'm currently using it on Windows and Linux successfully (please note JDK >=1.5 is required). Using this program I was able to learn about the tables on the server but not before I was able to ...