String to Rows


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 ;

Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

  • [url=]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="">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):