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

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql/plsql query question

Re: sql/plsql query question

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Thu, 6 Nov 2003 21:16:39 -0500
Message-ID: <oZKdnYQ77YEnnTaiRVn-iw@comcast.com>


daniel, be more specific

since the basis for both EXECUTE IMMEDIATE and DBMS_SQL is to construct a SQL statement in a varchar2 variable, how is it that 'if you do it correctly' you don't mask the object reference in a varchar2 (thus masking it from USER_DEPENDENCIES)

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1068163649.824295_at_yasure...
> roger wrote:
>
> >Mostly, it is because I try to avoid dynamic SQL at all costs.
> >
> >My main reason being that with DSQL you end up coding
> >schema object names (tables, columns, functions etc..)
> >as strings, rather than as symbols that are visible and can
> >be checked at compile time.
> >
> This is not true if you do it correctly.
>
> I'd suggest you go to http://asktom.oracle.com and look at the numerous
> examples Tom has created.
> Tom doesn't write junk.
> --
>
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Nov 06 2003 - 20:16:39 CST

Original text of this message

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