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: How to write trigger for ON_DELETE_CASCADE?

Re: How to write trigger for ON_DELETE_CASCADE?

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 16 Jun 2005 15:07:28 -0700
Message-ID: <1118959648.326671.36800@g44g2000cwa.googlegroups.com>

HansF wrote:
> On Thu, 16 Jun 2005 14:16:12 -0700, Chris ( Val ) interested us by
> writing:
>
> > Coming from C++, we often make use of namespaces to avoid such
> > name clashes - Actually, you can't really work in C++ without
> > some form of namespace qualification.
> >
> > Does Oracle have such a feature? or do you know if there is any
> > chance of it being introduced in future releases, if it does not
> > already exist?
>
> (Not Daniel, but answering anyway ...)

No problem - Feel free to chime in at any time :-)

> No, Oracle does not have such a feature. But this ain't really about
> Oracle - it's about the SQL language. And AFAIK, there is no formal
> namespace capability in the language spec. However qualifying by 'schema'
> and liberal use of double quotes gets around most of that 'limitation'.

Yes, I am aware of that, but it is not a silver bullet.

> I couldn't comment about Oracle's future releases other than what they
> publish in white papers - even if they happened to tell me. (Speculate,
> perhaps, but that wouldn't be binding.)

Uh, ok - Thanks for the information.
I do believe in namespaces though :-)

> That said .... namespaces are fun, aren't they! They allow one to have
> 17 different 'person's each exactly the same as the others, only
> different. No maintenance issue at all, because of the supporting docco
> developers leave behind when they finish the job and change companies. ;-)

Ever the optimist eh? :-)

Cheers,
Chris Val Received on Thu Jun 16 2005 - 17:07:28 CDT

Original text of this message

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