- 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
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:
Post Comments (Atom)
No comments:
Post a Comment