"Nuno Souto" <nsouto_at_optushome.com.au> wrote in message
news:dd5cc559.0205151517.4b43fe1e_at_posting.google.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3ce21b71$0$8510$ed9e5944_at_reading.news.pipex.net>...
> > Suggested list to be added to, deleted from etc
> >
>
>
> One more I've been hitting very often of late:
>
> - You cannot create declarative RI across schemas. Oracle doesn't let
> you do it.
> (could it be these people have never heard of the REFERENCES grant?)
>
> - Defining RI in application code is safer and less maintenance
> intensive than doing it in the databse.
Interesting the same thing is coming up frequently in
microsoft.public.sqlserver.programming.
I think this is probably a database myth. To be fair to developers there is
a DBA myth which says that you should only validate data in the database you
don't need to do it in the application.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu May 16 2002 - 03:38:55 CDT
