If you're just converting queries into Oracle stored procedures, I think it
would be fair to estimate a weekend to a week to get up to speed (depending
on your experience with SQL and the time you put in to it). But to get good
at what you're doing will take a longer...
I'd just like to point
Do not underestimate it! - I've been using T-SQL for 5 years and know it
pretty well. Got a job which was an oracle back end and tried to build the
equivalent in Oracle and had a nightmare - however if you are just using SQL
code in your CF using CFQueries then there wouldn't be much prob and you
If it is SQL in ColdFusion, don't worry. An understanding of SELECT, INSERT, UPDATE,
etc. will serve you well. If you have to program a complex report mining data out of
Oracle and published via the PL/SQL web toolkit over the WWW, may Fate smile upon you.
Your best bet is to search for
;hes.hmc.psu.edu]
Sent: Thursday, November 14, 2002 10:45 AM
To: CF-Talk
Subject: RE: SQL vs PL/SQL
If it is SQL in ColdFusion, don't worry. An understanding of SELECT,
INSERT, UPDATE, etc. will serve you well. If you have to program a complex
report mining data out of Oracle and published via
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.
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
6 matches
Mail list logo
