select_anonimage.sql

来自「在Oracle数据库11g中管理DICOM格式数据」· SQL 代码 · 共 13 行

column id format 99;
column PATIENT_NAME format A30;
column PATIENT_ID format A10;
select id, 
        extractValue(t.anonDicom.metadata, 
        '/DICOM_OBJECT/*[@name="Patient''s Name"]/VALUE', 
        'xmlns=http://xmlns.oracle.com/ord/dicom/metadata_1_0') as "PATIENT_NAME", 
        extractValue(t.anonDicom.metadata, 
        '/DICOM_OBJECT/*[@name="Patient ID"]', 
        'xmlns=http://xmlns.oracle.com/ord/dicom/metadata_1_0') as "PATIENT_ID" 
from medical_image_table t;