Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql/plsql query question
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