OT: SQL vs PL/SQL

2002-11-14 Thread Casey C Cook
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

RE: SQL vs PL/SQL

2002-11-14 Thread Andy Ewings
ob and you should be able to pick up the syntax differences as you go along -Original Message- From: Casey C Cook [mailto:ccook22@;csc.com] Sent: 14 November 2002 16:34 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/SQ

RE: SQL vs PL/SQL

2002-11-14 Thread Lincoln Milner
o does the learning curve. My 2ยข, -lincoln -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,

RE: SQL vs PL/SQL

2002-11-14 Thread Jim Campbell
to:lmilner@;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 an

RE: SQL vs PL/SQL

2002-11-14 Thread Lofback, Chris
1 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

Re: SQL vs PL/SQL

2002-11-14 Thread Deanna Schneider
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 publishe

RE: SQL vs PL/SQL

2002-11-15 Thread Jeffrey Polaski
-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

Re: OT: SQL vs PL/SQL

2002-11-14 Thread Jochem van Dieten
Casey C Cook wrote: > 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 ju

transact(ms sql) VS PL SQL(Oracle)

2002-06-11 Thread Amanda Stern
Does anyone have a good article or experiences on the differences between ms sql and oracle databases... thanks, --- phumes1 <[EMAIL PROTECTED]> wrote: > I don't know whats happening... > > The contents of my output.txt file still contains > the following. The output > to the screen (console)

RE: transact(ms sql) VS PL SQL(Oracle)

2002-06-11 Thread Bryan Love
re must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:52 PM To: CF-Talk Subject: transact(ms sql) VS PL SQL(Oracle) Doe