Re: function in sql

I'll take a stab at it.

Recall how pl/sql checks direct privs instead of privs granted to a role? This saves time and space.

Purity level helps save time and space in checking whether or not a piece of code updates the database, a package, the runtime environment.

Oracle wants to run as many pieces of code simultaneously, independent of each other. In order to do that, however, it needs either to restrict what the code will do or have all sorts of protection in place and special coding for reentrancy and the like. Look at the great lengths Oracle goes through in providing consistent snapshots of the database. Lots and lots of code and structures.

As more and more developers work on Oracle and cost of CPU, memory and disk go down, Oracle can put more and more checking and protection in place.

Oracle 8i requires less purity than 8, 8 required less purity than 7, and before that we did not have pl/sql to worry about. Just like in 8i you can create an index online. Before 8i you could rebuild an index with a nasty share lock on the table. But index rebuilds are a boon to those who remember not having them at all before.
----- Original Message -----
From: Ajay K <ajay_at_tems.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 31, 2000 1:01 PM
Subject: Re: function in sql

> Can someone explain me what is logic behind purity level.(pragma restrict
> reference)
>
> TIA
> ajay
>
> "Gogala, Mladen" wrote:
>
> > The function should be declared as 'DETERMINISTIC'.
> >
> > -----Original Message-----
> > Sent: Tuesday, October 31, 2000 10:15 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi Wolfgang,
> >
> > as far as I know there is no such parameter. But I've read somewhere in
> > oracle whitepapers that 8i doesn't require pragmas anymore, if the purity
> > level was breaked you will get an error at runtime. I didn't check it yet.
> >
> > Ed
> >
> > >
> > >
> > > Hello,
> > > to use funktions in sql I would expect that I have to
> > > define a pragma restrict_reference.
> > >
> > > Some one told me that I have to set a init.ora-parameter
> > > to allow all functions to run in sql-statements
> > >
> > > Is this true ?
> > >
> > >
> > > Wolfgang Ludewig
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: wolfgang.ludewig_at_systor.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: Shevtsov, Eduard
> > INET: EShevtsov_at_flagship.ru
> >
> > 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: Gogala, Mladen
> > INET: MGogala_at_oxhp.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: Ajay K
> INET: ajay_at_tems.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
Received on Tue Oct 31 2000 - 14:07:11 CST