Please, someone. Savor a thick and tasty Guinness for me... I even had someone call my house wanting to do a survey on beer. I laughed at him and hung up.
Lisa Koivu Oracle Database BABY OVEN Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -----Original Message----- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: pl/sql is INTERPRETED? > > >-Have another beer > > Excellent advice. I think I'll do just that. > > Dave > > -----Original Message----- > Sent: Thursday, May 02, 2002 2:29 PM > To: Multiple recipients of list ORACLE-L > > > yeah, yeah Chris, whatever. > > Have another beer and do some creative writing. > > ;-{) > > Jared > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:48 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: RE: pl/sql is INTERPRETED? > > > Java this...PERL that....COBOL rules!!!! It's easy to write and > maintain...back to writing my book... > > -----Original Message----- > Sent: Thursday, May 02, 2002 2:14 PM > To: Multiple recipients of list ORACLE-L > > > It ain't that tough. We're not talking about taking a programming > class without any experience, I've done a bit of it before. > > Learning all the API's, etc.: that would take some time. > > The language? It isn't that difficult, though I would be > hard put to write any at the moment. The job I was going > to use Java on was at Enron, and we all know what happened > to that. > > It's been a year since I took the class, and I *much* prefer > Perl. It can run circles around Java for most stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously do not know it. > Syntax is one thing design is another. I would love to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's is > > another story, but Java as a language is pretty simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > > learned fairly easily in comparison to the many other choices out > there. > > > However, it takes a bit of database savvy to do it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college that the same people > failing > > > the simple entity-relationship modeling portion of the class that had > aced > > > the Op Systems and networking classes we took. I nearly failed both > > > classes, they were so complex. I was the teacher's pet in the db > class > > > because I asked him questions that made him think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - night student, straight > > > from > > > work.) > > > > > > What's easy for who is dependent on the person's strengths. > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -----Original Message----- > > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > > short period of time, or for that matter, any other language. > > > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, > and > > > > he tore into many real-life examples of PL/SQL. Supposedly, these > were > > > > written > > > > by developers that knew what they were doing. > > > > > > > > Granted, if a smart developer sits down and reads Feuerstein's > Learning > > > > PL/SQL and Best Practices books, then perhaps they will be good. But > > > who > > > > the hell has free time? There is no free time on any project or > effort > > > > that > > > > I know of!! I'm struggling with trying to improve my Oracle DBA > skills, > > > > plus some developers skills so I can speak their language when they > blow > > > > out > > > > OPEN_CURSORS or something. My head is swimming in the stupid > technical > > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, > BC4J, > > > > JDBC, > > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me > what > > > > all > > > > those mean, because I can't keep them straight. But I do keep > hearing > > > > that > > > > XML is going to put me out of a job, so I guess I should learn > > > > that...whatever that is. Isn't XML an add-on, or extension, or > something > > > > to > > > > DML??? > > > > > > > > Now where the heck did I hide that bottle... > > > > > > > > -----Original Message----- > > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Lisa, > > > > > > > > You are right about the debate between PL/SQL & Java (or anything > else > > > > outside of the db). > > > > > > > > In my mind, the deciding factor (and something that is *never* > mentioned) > > > > is > > > > what programming langauage the organization is satisfied > with/settled > > > > upon. > > > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very > short > > > > period of time. This means that development and maintenance costs > are > > > > relatively low. If an IT shop is stronger in Java, then they should > > > > probably program in Java, or Cobol, or Ada, or whatever the flavor > of the > > > > decade happens to be (lets bring back APL!). > > > > > > > > IT tool selection/standards should be the deciding factor. > > > > > > > > Tom Mercadante > > > > Oracle Certified Professional > > > > > > > > > > > > -----Original Message----- > > > > Sent: Tuesday, April 30, 2002 11:34 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > This is something that's been debated on the list in the past. The > > > > general > > > > consensus was: > > > > > > > > For manipulating data in the database, nothing beats pl/sql. It is > well > > > > suited for this purpose. > > > > > > > > For everything else, java could beat it. > > > > > > > > I am sure fellow list members will post links describing studies. I > > > > remember seeing these last year. > > > > > > > > Stefan, have you tried running your own test? There's a sure fire > way to > > > > convince yourself. Even a small test (no fancy code) would suffice. > > > > > > > Wish I > > > > had more time to play... > > > > > > > > Lisa Koivu > > > > Oracle Database Monkey Mama > > > > Fairfield Resorts, Inc. > > > > 5259 Coconut Creek Parkway > > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > > > -----Original Message----- > > > > > From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] > > > > > Sent: Tuesday, April 30, 2002 10:49 AM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: AW: pl/sql is INTERPRETED? > > > > > > > > > > Hi > > > > > > > > > > how about Java within Oracle. What do you think about it ? > > > > > When does it make sense to use Java instead of PL/SQL ? > > > > > The problem is that I dislike a mix of different languages > > > > > within an application. It messes things up. > > > > > But maybe it makes sense to use PL/SQL for most stuff and > > > > > Java for some specific things (perhaps accessing a file > > > > > or using a network resource ?). > > > > > As far as I know, there is an option to compile the Java into > > > > > platform dependend code, which would make it execute much faster > > > > > then bytecode (and PL/SQL?), since the later has to be interpreted > > > at > > > > > run-time. > > > > > > > > > > > > > > > Any opinions ? > > > > > > > > > > Regards, > > > > > > > > > > > > > > > -----Urspr|ngliche Nachricht----- > > > > > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > > > Gesendet: Dienstag, 30. April 2002 16:09 > > > > > An: Multiple recipients of list ORACLE-L > > > > > Betreff: Re:pl/sql is INTERPRETED? > > > > > > > > > > > > > > > Lisa, > > > > > > > > > > It is both true & false at the same time. Obviously any > anonymous > > > > > blocks > > > > > you submit to the database are fully interpreted. PL/SQL that you > > > > > store in > > > > > the > > > > > database as procedures, functions, and packages get partially > compiled > > > > > into > > > > > a > > > > > p-code. This makes the code ready for execution, but retains a > modular > > > > > design > > > > > so that if your DBA reloads catproc your code is not totally > destroyed. > > > > > Where I > > > > > think PL/SQL buys us a lot of performance is in reducing the > > > > > communications > > > > > outside of the database that is otherwise needed. There's no JDBC > > > > > > > > driver > > > > > > > > > or > > > > > other miscellaneous mess (like SQL*Net) required. It's all > handled > > > > > > > > inside > > > > > > > > > the > > > > > kernel. Now the bad part about PL/SQL that Java handles better is > > > > > platform > > > > > independence. You can run Java on your client, the apps server or > > > > > database > > > > > without a problem. PL/SQL on the other hand must be run in the > > > > > > > > database. > > > > > > > > > Dick Goulet > > > > > > > > > > ____________________Reply Separator____________________ > > > > > Author: "Koivu; Lisa" <[EMAIL PROTECTED]> > > > > > Date: 4/29/2002 2:52 PM > > > > > > > > > > Can this be true? How can this be? If it's optimized to > manipulate > > > > > > > > data > > > > > > > > > within the database, how can it be fast if it's interpreted (like > that > > > > > slow > > > > > poke, Java)? > > > > > > > > > > I see this on Connor's website www.oracledba.co.uk under > > > > > > > > explicit/implicit > > > > > > > > > cursors, under pl/sql. What on earth? > > > > > > > > > > Can someone elaborate, namely, Connor?? Please help me understand > > > > > > > > this... > > > > > > > > > My "green" may be showing, but my gosh. > > > > > > > > > > Lisa Koivu > > > > > Oracle Database Baby Oven > > > > > Fairfield Resorts, Inc. > > > > > 5259 Coconut Creek Parkway > > > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: Koivu, Lisa > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > > > -------------------------------------------------------------------- > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > (or the name of mailing list you want to be removed from). You > may > > > > > also send the HELP command for other information (like > subscribing). > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > > > -------------------------------------------------------------------- > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > (or the name of mailing list you want to be removed from). You > may > > > > > also send the HELP command for other information (like > subscribing). > > > > > > > > > > > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: Stefan Jahnke > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > > > -------------------------------------------------------------------- > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > (or the name of mailing list you want to be removed from). You > may > > > > > also send the HELP command for other information (like > subscribing). > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Koivu, Lisa > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > -------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Mercadante, Thomas F > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > -------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Grabowy, Chris > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California -- Public Internet access / Mailing > Lists > > > > -------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).