Scott Schwab

Subscribe to Scott Schwab feed
Scott Schwab's Blog about SQL, PL/SQL, and other stuff. This is blog will not be updated, since I have much less work with PL/SQL, SQL and databases in general.Scott Schwab
Updated: 2 days 14 hours ago

A Simple Dual

Thu, 2006-02-23 20:14
What happens when this sql is called, but the tag you are looking for, is not in the XMLTYPE? SELECT extractvalue(my_xmltype, my_xpath_to, my_namespace) FROM dual; (1) Raise no data found exception (2) Returns null Answer: (2) returns null, so if you want to check to see if the text node exist for a x_path, don't expect a EXCEPTION clause to check it.Scott Schwab

first post

Mon, 2006-02-20 21:06
Hello worldScott Schwab