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 out that, while closely related, PL/SQL and SQL are
two very different languages. PL/SQL is more of a "regular" procedural
programming language and the things you do with it are different than the
things you do with straight SQL. PL/SQL is used more for the things you do
with CF, Java or any other "regular" programming language. PL/SQL was just
designed for a particular niche, the Oracle database, so it has db specific
features, too. SQL is a (fairly) standard way to interact with databases and
is more of a functional language. When you write PL/SQL you'll use SQL.
I you can download Oracle from their web site (or at least you used to be
able to) and play around with it. That and the docs should be a good
start...
Jeff Polaski
"The cow is of the bovine ilk;
One end is moo, the other, milk."
-- Ogden Nash
-----Original Message-----
From: Casey C Cook [mailto:ccook22@;csc.com]
Sent: Thursday, November 14, 2002 8: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
