Columns 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.

drop table t ;

drop type varray_type ;
drop type name_value_varray ;
drop type name_value_pair ;

exit

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

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

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

SQL Snippets ™: Tutorials for Oracle Developers

Columns to Rows

Cleanup

Linking to SQL Snippets ™