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

Home -> Community -> Usenet -> c.d.o.server -> Re: A Primary Key and Foreign key

Re: A Primary Key and Foreign key

From: Satya <sghattu_at_hotmail.com>
Date: 1998/12/01
Message-ID: <01be1d74$e8ecd6c0$5f7e8d94@y2kuser.sherwin.com>#1/1

hi u can declare a before insert trigger to disable all the PK's and FK's b4 u insert rows into the database....

Diego Pafumi <dpafumi_at_us.oracle.com> wrote in article <365AD764.C8E6E1EF_at_us.oracle.com>...
> Hi gurus !!!
> I have a little question. I received an application without any
> specificaton. Actually I have to insert in many tables some data
> manually.
> So my question is: How can I "suspend" for a moment all the Primary Keys
> and Foreign Keys?? Also I'd like to know if there is any eay to create
> something like a "Data Model". I think that I have to disable all the PK
> and FK before to insert. Is that right?? Or I have to disable more
> things??
>
> Thanks in advance
>
> Diego
>
>
  Received on Tue Dec 01 1998 - 00:00:00 CST

Original text of this message

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