[SQL] Accessing array datatype

[maria s]

Hi All,
I have an array column in a table.
How can I fetch the elements separately( ie, select arr[1],arr[2]...arr[n])
as a column,
 when I don't know how many elements are there in the array?

Thanks for your help.

Maria