SQL Language (MOSC)

MOSC Banner

Chain of update

edited Dec 12, 2011 3:44AM in SQL Language (MOSC) 7 commentsAnswered
Hi everybody,

I have these 3 update statements 

-- table KID_XML_GTT is
-- table_xml               sys.xml_type,
-- validate_message        long,
-- validate_status         varchar2(10)

--- Clean my XML, remove null tags
UPDATE KID_XML_GTT
   SET TABLE_XML =
          (DELETEXML (TABLE_XML, '/parts/part//*[.=""]', G_NSPACE_PATH));

--- Validate the cleaned xml against a XSD document
UPDATE KID_XML_GTT
   SET VALIDATE_MESSAGE = SCHEMAVALIDATION (TO_CLOB (TABLE_XML), L_XSD);

--- Get standard status from validation
UPDATE KID_XML_GTT
   SET VALIDATE_STATUS = GET_STATUS (VALIDATE_MESSAGE);

I'm wonder if it is possible to write all 3 statements in only 1.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center