Varying IN Lists


Run the code on this page in SQL*Plus to create the sample tables, data, etc. used by the examples in this section.

Be sure to read Using SQL Snippets ™ before executing any of these setup steps.

column val format a10

create table t
  key number,
  c   varchar2(10)

insert into t values ( 1, 'v1' );
insert into t values ( 2, 'v2' );
insert into t values ( 3, 'v3' );
insert into t values ( 4, 'v4' );
insert into t values ( 5, 'v5' );


create type integer_varray_type is varray(10) of number(38) ;

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: Varying IN Lists - Setup[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

  • <a href="">SQL Snippets: Varying IN Lists - Setup</a>

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

  • Link Text : SQL Snippets: Varying IN Lists - Setup
  • URL (href):