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: HansF <News.Hans_at_telus.net>
Date: Thu, 16 Jun 2005 21:40:51 GMT
Message-Id: <pan.2005.06.16.21.43.53.839997@telus.net>


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, 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'.

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.)

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. ;-)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Thu Jun 16 2005 - 16:40:51 CDT

Original text of this message

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