Sure you can.

The role of the FK constraint is to protect data.
In your example and with a 1:1 or 1:n relationship (with a "must have" FK
on table B side), the FK would prevent you of inserting a B.user_id which
does not exist on the A side.

Regards,

Tajana

__________________________________________________




"shivas "
<oracledba-ezmlmshield-
x72013543.[Email Address Removed] An
azydba.com> "LazyDBA Discussion"
<[Email address protected]
29.04.2008 10:09 Kopie

Thema
SQL doubt:











Hi experts,

SQL doubt:

I have two table "A" and "B" in table A i have column called user_id with
constrain pk and same column user_id i have in "B" table but NOT fk..

can i FETCH data joining this two tables. join like A table user_id = B
table user_id.


Thanks

siva.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page