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 just > trying to gauge how much work I will have to do to to pick up PL/SQL, > a weekend....a week...a month?
I would ask if he was sure the requirement was to write queries in PL/SQL and not writing procedures in PL/SQL. If the objective is to convert some existing queries to procedures and then granting only execute rights for procedures and not to use pass-through queries anymore it takes about an hour to learn it. But if you need to write complex procedures it is going to take a long time. Don't forget that PL/SQL is a procedural language, it is not some SQL dialect. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
