I installed Oracle 10g express edition on my Thinkpad. I’ve had PL/SQL developer on my work machine for a while but I don’t use it much because I don’t have a database to play around with. I created some simple tables, triggers, and sequences in my test database.
At work we’ve been debugging some ETL (extract/transfer/load) issues with our Operational Data Store. Everyone has been using PL/SQL developer or TOAD. I’m kind of in the dark when I see people using these tools because I’m not sure what all they use them for. Sometimes they use them to find database objects; sometimes they use them to help see what tables are used by a view. Now I can get a sense of what PL/SQL developer does and what Oracle security looks like.