joaotelles
asked on
update two tables in single query oracle
Hi,
I have 2 tables, dp_cardprofile and dp_simapplication. Both tables have the same identifier, DPCP_ID and they have a foreign key relation between them.
I need to update this dpcp_id in both tables, but if I update in just one, I receive an error.
ORA-02291: integrity constraint (DPOWNER.DP_SIMAPPLICATION _FK_DP_CAR DPR)
violated - parent key not found
How can I do this update in DPCP_ID in Oracle 10?
desc dp_cardprofile
Name Null? Type
-------------------------- ---------- ----- -------- -------------------------- --
DPCP_ID NOT NULL NUMBER(38)
DPCP_NAME NOT NULL VARCHAR2(50)
desc dp_simapplication
Name Null? Type
-------------------------- ---------- ----- -------- -------------------------- --
DPSA_ID NOT NULL NUMBER(38)
DPCP_ID NOT NULL NUMBER(38)
I have 2 tables, dp_cardprofile and dp_simapplication. Both tables have the same identifier, DPCP_ID and they have a foreign key relation between them.
I need to update this dpcp_id in both tables, but if I update in just one, I receive an error.
ORA-02291: integrity constraint (DPOWNER.DP_SIMAPPLICATION
violated - parent key not found
How can I do this update in DPCP_ID in Oracle 10?
desc dp_cardprofile
Name Null? Type
--------------------------
DPCP_ID NOT NULL NUMBER(38)
DPCP_NAME NOT NULL VARCHAR2(50)
desc dp_simapplication
Name Null? Type
--------------------------
DPSA_ID NOT NULL NUMBER(38)
DPCP_ID NOT NULL NUMBER(38)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@EE admins
SQL Server????????
SQL Server doesn't know ORA errors or VARCHAR2 data types, neither the code provided above!!!!
So, where the heck is the connection (apart from awarding a solution that totally differs from the origin subject)?!?!?
SQL Server????????
ORA-02291: integrity constraint (DPOWNER.DP_SIMAPPLICATION_FK_DP_CAR DPR)
violated - parent key not found
How can I do this update in DPCP_ID in Oracle 10?
desc dp_cardprofile
Name Null? Type
------------------------------------ ----- -------- -------------------------- --
DPCP_ID NOT NULL NUMBER(38)
DPCP_NAME NOT NULL VARCHAR2(50)
SQL Server doesn't know ORA errors or VARCHAR2 data types, neither the code provided above!!!!
So, where the heck is the connection (apart from awarding a solution that totally differs from the origin subject)?!?!?
Relax dude.
The asker included the SQL Server zone in this question, so it's appropriate to give a SQL answer, although I didn't expect it to get full points as the question had Oracle-specific language.
I would think though that everything else being equal an Oracle-specific answer would be more relevant than a SQL Server-specific answer for this question. So .. it seems appropriate that the asker should chime in on that.
The asker included the SQL Server zone in this question, so it's appropriate to give a SQL answer, although I didn't expect it to get full points as the question had Oracle-specific language.
I would think though that everything else being equal an Oracle-specific answer would be more relevant than a SQL Server-specific answer for this question. So .. it seems appropriate that the asker should chime in on that.
I didn't mean to bother anyone, so sorry for my offensive reaction ;-)
Moreover, I am not that points addicted, I just wanted to state that something was kind of wrong here...
Moreover, I am not that points addicted, I just wanted to state that something was kind of wrong here...
It's a valid point.
ASKER
tks and sry the zone confusion.
In Oracle you can update 2 or more tables within 1 statement...