How to join a varray(20) type returned from a function with a table?
I have a type defined as follows:
CREATE OR REPLACE TYPE type1 IS varray(20) of varchar2(20)
And I have a function func1 use type1 as return value. I try to join the return value with a table, how can I do so?
The following ways are not working:
FROM tab2, (select func1('abc') col1 from dual) tab1
WHERE tab2.col2 = TO_CHAR(tab1.col1)
select * from tab2 where tab2.col2 in (select func1('abc') col1 from dual)
Thanks a lot
Can you give a little background on what you are trying to achieve?
It may be possible to do what you are trying, but there may be a better way.
Click Here to Expand Forum to Full Width