3 Replies Latest reply on Feb 3, 2012 9:39 AM by José Mª

    Example XML Schema query OrdImage Metadata * OFFLINE

    José Mª
      Hello, I'd like information (autoformation) in this SCENARIO:

      Table_NAME: PHOTO

      Columns:
      PK_GUID - CHAR(32) -> UUID
      IMG - ORDSYS.ORDIMAGE
      ORIMAGE_METADATA - XMLTYPE

      PL/SQL process extract OrdImage Metadata from IMG and STORE IN ORIMAGE_METADATA, witch one is accesible via JDeveloper 11g Database Explorer.

      Server (RHEL5 x64) is OFFLINE (I think there's no problem).

      Required:

      SQL Sentence (no PL/SQL), to see PK_GUID and all images width from ORIMAGE_METADATA
      SELECT PK_GUID, <CODE_REQUIRED>
      FROM 
        PHOTO;
      Any help or link is apretiated.

      Regards.

      Edited by: 911572 on 01-feb-2012 12:18