Tuesday 18 June 2013

XMLType in SQL Developer

I thought I'd add this as for someone new to SQL Developer, this is not obvious at first glance. When creating a table with column(s) of type XMLType, the type is not available via the standard Create Table wizard. Below are the full steps to use that datatype:


  • Right-click on the 'Tables' node in the 'Connections' view
  • Select 'New Table'
  • Check the 'Advanced' check box located in the top right corner - This will show an alternate 'Create Table' dialogue which hosts considerably more functionality
  • In the 'Column Properties' area, select the 'Complex' radio button for datatype
  • Choose the SYS schema; the XMLType will be available in the drop down

No comments:

Post a Comment