Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: pl/sql is INTERPRETED?

Re: pl/sql is INTERPRETED?

From: <Jared.Still_at_radisys.com>
Date: Thu, 02 May 2002 11:38:54 -0800
Message-ID: <F001.00456A30.20020502113854@fatcity.com>


And here I thought this was a private message.

You have unfortunately caught me in a rather stressful week, and I find great relief in greeting arrogance with sarcasm.

Don't worry about it, what I learned in a week would take you a month.

Jared

Alex <axs_at_m-net.arbornet.org>
Sent by: root_at_fatcity.com
05/02/2002 12:23 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: pl/sql is INTERPRETED?


You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably say any language is easy to learn; it is just ifs, elses, and loops.

On Thu, 2 May 2002 Jared.Still_at_radisys.com wrote:

> 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 <axs_at_m-net.arbornet.org>
> Sent by: root_at_fatcity.com
> 05/02/2002 08:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> 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:cgrabowy_at_fcg.com]
> > > > 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:Stefan.Jahnke_at_bov.de]
> > > > > 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: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> > > > > 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" <lisa.koivu_at_efairfield.com>
> > > > > 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: lisa.koivu_at_efairfield.com
> > > > >
> > > > > 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com
> > > > >
> > > > > 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: ListGuru_at_fatcity.com (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: Stefan.Jahnke_at_bov.de
> > > > >
> > > > > 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: ListGuru_at_fatcity.com (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: lisa.koivu_at_efairfield.com
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: cgrabowy_at_fcg.com
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com
> >
> > 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: ListGuru_at_fatcity.com (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: axs_at_m-net.arbornet.org
>
> 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: ListGuru_at_fatcity.com (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: axs_at_m-net.arbornet.org

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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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).
Received on Thu May 02 2002 - 14:38:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US