Blog

Oracle ‘isnumeric’ function

A possible implementation is to simply try to assign the string to a number and catch any exceptions. If something goes wrong then it's not a number!

Extracting XML information using PL/SQL

Since version 9, Oracle has had support for XML data built into the heart of the database. Sometimes however, it is not immediately obvious how to get data from an XML string, particularly if, like me, it's not something you do that often!

Tags

  • oracle (8)
  • Mac OS (6)
  • Oracle (6)
  • SQL (5)
  • apex (4)
  • mac os (3)
  • iPhone (3)
  • script (2)
  • GIS (2)
  • map (2)