How do you copy information into another table with constraint?

Plural · #1 (**permalink**) 12-11-11, 19:18

I have the following table:
Patient(patientNumb, SS, name, dateOfBirth, address, dateAdmitted, clinic)

I'd like to insert all the values into another table called PatientB using:

Code:

INSERT INTO PatientB SELECT * FROM Patient

but the problem is the integrity constraint on patientNumb and clinic...is there a way that I can insert all those and updating the value at the same time or bypass it?

anacedent · #2 (**permalink**) 12-11-11, 20:17

CONSTRAINT exist to maintain data integrity.
Do what is required to maintain data integrity.

flyboy · #3 (**permalink**) 12-11-11, 23:18

Quote:

Originally Posted by Plural

is there a way that I can insert all those and updating the value at the same time or bypass it?

To be honest, I do not understand this question at all.

My first thought was error logging - it is described e.g. in this article: http://www.oracle-base.com/articles/...ging_10gR2.php
Also it can cover MERGE statement (also called upsert) - it is described e.g. here: http://www.oracle-base.com/articles/...cements10g.php

If none of this covers your requirements, you should precise your question, preferably represented with a test case (CREATE TABLE + INSERT statements for sample data, expected result with description of steps leading to it).

Internet Services

Web Development

Digital Marketing

Consumer Tech