Skip to content

Instantly share code, notes, and snippets.

@velll

velll/varray_column_value.sql

Created July 10, 2017 11:33
Show Gist options
  • Save velll/8572c1b9cb145d46e9246d90534271b3 to your computer and use it in GitHub Desktop.
Save velll/8572c1b9cb145d46e9246d90534271b3 to your computer and use it in GitHub Desktop.
Download ZIP
VARRAY column_value
Raw
varray_column_value.sql
create table tab_with_arr(
id number,
val NUMBER_ARRAY)
insert into tab_with_arr
select 1, number_array(1,2,4,5)
from dual
select t.id, c.column_value
from tab_with_arr t,
table(t.val) c
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment