A lot of my present work revolves around generating reports and listings from Oracle, so my SQL skill has improved somewhat from before. I've also gained some experience with writing PL/SQL, working on SQL*PLus, SQL Loader and a bit of simple database administration. Lots of odds and ends and nothing fancy. If I leave this job at least I can say that I have around 6 months of experience working on Oracle. It's peanuts in terms of experience but at least it's better than nothing I guess.
I've never worked on very large data sets before but now it's a daily affair. Read up on indexing to help speed up queries but I'm still lagging behind in my knowledge of things like SQL tuning. Since much of my work revolves around the database, so the faster the queries on the database, the faster I clear my stuff and go home.
TOra is a competent replacement for TOAD, and if you're looking for a tool to replace SQL*Plus this is definitely it.
No comments:
Post a Comment