Here's a small tip. I moved to PL/SQL from plain vanilla SQL (basically using MS Access) and I quickly found there are two critical PL/SQL functions that you must know:
NVL() and DECODE() Make sure you learn 'em and use 'em. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com > -----Original Message----- > From: Casey C Cook [mailto:ccook22@;csc.com] > Sent: Thursday, November 14, 2002 11:34 AM > To: CF-Talk > Subject: OT: SQL vs PL/SQL > > > If someone came to you and said we need someone to work with > Oracle and > PL/SQL to write some queries, but all you knew was SQL, how > much of PL/SQL > would you say you already knew, knowing there are some syntax > differences > between the two query writing languages? Im just trying to > gauge how much > work I will have to do to to pick up PL/SQL, a weekend....a > week...a month? > > Thanks, > Casey Cook > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com