Help with Oracle Query
Posted
by Gnaniyar Zubair
on Stack Overflow
See other posts from Stack Overflow
or by Gnaniyar Zubair
Published on 2010-04-21T08:44:18Z
Indexed on
2010/04/21
12:53 UTC
Read the original article
Hit count: 409
I want to delete all the records where field name class="10010"
from Table A and AentryId = BentryId
from Table B.
if i delete the entryId 12 which matches className=10010 from Table A and the same time that same id should delete from Table B also.
Table A:
AentryId className
12 10010
13 10011
14 10010
15 10011
Table B:
BentryId name
12 xyz
13 abc
14 aaa
© Stack Overflow or respective owner