- 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
Showing posts with label SQL Developer. Show all posts
Showing posts with label SQL Developer. Show all posts
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:
Subscribe to:
Posts (Atom)