-
How to join a varray(20) type returned from a function with a table?
Hi,
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:
select *
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|