String to Rows: Cleanup

SQL Snippets: Tutorials for Oracle Developers

Home SQL Features SQL Techniques Miscellany About Blog Site Map

> SQL Techniques > String to Rows > Cleanup

- String to Rows
	UNION ALL Method
	Integer Series Generator Method
	Integer Series Generator Method - 10g+
	Hierarchical Methods
	Dynamic PL/SQL Method
	MODEL Method
	XML Method
	Performance Comparison
	Setup
	Cleanup

< Previous

Read Using SQL Snippets before using any of this site's code or techniques on your own systems.

String to Rows

Cleanup

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 type varchar2_varray_type ;
drop type integer_varray_type ;

drop view integer_table ;

drop table t  ;
drop table t2 ;
drop table t3 ;
drop table t5 ;
drop table t6 ;
drop table integers ;

drop function csv_to_varray     ;
drop function csv_to_varray_2   ;
drop function csv_num_to_varray ;

exit

Previous Topic

: Setup

[<] Previous Topic [^] Top of page

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-12025.html]SQL Snippets: String to Rows - 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-12025.html">SQL Snippets: String to Rows - Cleanup</a>

To link to this page in other web sites use the following values.

Link Text : SQL Snippets: String to Rows - Cleanup
URL (href): http://www.sqlsnippets.com/en/topic-12025.html

Ads by NSC Cards

Mabel's Labels™-- Labels for the stuff kids lose!™

Ads by Joe

Pay it Forward

Did the free information on this site help you? Consider repaying the favour by helping others.

Next time you see a discussion forum question or blog topic about something you've seen covered on SQL Snippets help out by replying with a link to the SQL Snippets topic.

It's easy to do. Simply cut and paste code from the Linking to SQL Snippets section at the bottom of this page.

Terms and Conditions of Use Disclaimer Privacy Policy

This page was first published on April 5, 2007.

The views expressed on this site are my own and do not necessarily reflect the views of Oracle.