Join to an oracle table valued function

Viewed 13430

Is is possible to join to an Oracle table valued function?

SELECT 
   *
FROM 
  SOME_TABLE a
INNER JOIN 
  TABLE(GET_TABLE_LIST()) b ON = a.COL_A = b.COL_A
3 Answers
SELECT a.*, b.*
from table_name a cross join table ( myFunc(a.id) ) b
Related