Also, there's a gigantic heavy book that not only impresses people walking past your cubicle (and has its own gravitational field) but also is one of the most indespensable books in my programming reference library.
Oracle 8i: The Complete Reference by Loney and Koch http://www.amazon.com/exec/obidos/ASIN/0072123648/qid=1037295710/sr=2-2/ref= sr_2_2/104-3361319-6501550 YMMV, but I pull it out whenever I have a PL/SQL or vanilla SQL problem. Hasn't failed me yet (if the organization is a little scattershot in places). - Jim -----Original Message----- From: Lincoln Milner [mailto: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 and published via the PL/SQL web toolkit over the WWW, may Fate smile upon you. Your best bet is to search for answers to questions you might have, and go to Oracle's web site for some docs. on PL/SQL reference. They're big and (*gasp*) dense, but they'll provide you with more information than you ever wanted. I would say, good rule of thumb, as complexity of said project increases, so 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, 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
