Menu

Oracle Database Tablolarda veriler Silme Örnekleri

- Oracle

select * from image im where im.sr_key in (
select sr.sr_key from series sr where sr.st_key in (
select st_key from study where patientid =’L0124243′ )
)

/*image */
delete from image im where im.sr_key in (
select sr.sr_key from series sr where sr.st_key in (
select st_key from study where patientid =’L0124243′ )
)
/*seriler*/
delete from series sr where sr.st_key in (
select st_key from study where patientid =’L0124243′ )
/*çalışma*/
delete from study where patientid =’L0124243′
/*patient */
delete from patient where patientid =’L0124243′

 

Emin Yardım

Leave a Reply

Your email address will not be published. Required fields are marked *