Actually, depending on what version of Oracle you're using, you might not need decode() anymore. Case statements are available in pl/sql as of 9i, which effectively replace decode().
Also, I would say that the book recomended is geared more toward's oracle SQL than PL/SQL, though the same publisher has an Oracle 8 PL/SQL Programming book. Like others have said, what you will need to do really determines how difficult it is to learn. Basic syntax in PL/SQL is similar to SQL, but it does go way beyond. I pretty much feel like I could do Oracle stuff everyday all day and still not know it all. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.

