Read Using SQL Snippets ™ before using any of this site's sample code or techniques on your own systems.
String to Columns
Run the code on this page to drop the sample tables, procedures, etc. created in earlier parts of this section. To clear session state changes (e.g. those made by SET, COLUMN, and VARIABLE commands) exit your SQL*Plus session after running these cleanup commands.
Be sure to read
Using SQL Snippets ™
before executing any of these setup steps.
drop table t1 ;
drop view t1_xml_1 ;
drop view t1_xml_2 ;
Linking to SQL Snippets ™
To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.
- [url=http://www.sqlsnippets.com/en/topic-11993.html]SQL Snippets: String to Columns - Cleanup[/url]
To link to this page in HTML documents or Blogger comments cut and paste this code.
- <a href="http://www.sqlsnippets.com/en/topic-11993.html">SQL Snippets: String to Columns - Cleanup</a>
To link to this page in other web sites use the following values.
- Link Text : SQL Snippets: String to Columns - Cleanup
- URL (href): http://www.sqlsnippets.com/en/topic-11993.html