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 Schwabhttp://www.blogger.com/profile/14014003619353346507noreply@blogger.comBlogger22125
Updated: 9 hours 30 min 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 Schwabhttp://www.blogger.com/profile/14014003619353346507noreply@blogger.com0

first post

Mon, 2006-02-20 21:06
Hello worldScott Schwabhttp://www.blogger.com/profile/14014003619353346507noreply@blogger.com0

Pages