TABLE Function in a Join

From: klabu <nosuchuser_at_gmail_dot_com>
Date: Tue, 10 Oct 2006 11:10:50 -0400
Message-ID: <12indvrdcnkt99f@corp.supernews.com>

10gR2

Need some help here, never seen it done before....

SELECT --...whatever...
  2 FROM taba
  3 JOIN tabb
  4 ON taba.pk = tabb.pk
  5 JOIN tabc
  6 ON tabc.fk = taba.pk

  7  JOIN TABLE(apkg.afunc(taba.pk,
  8                        taba.col_x,
  9                        tabb.col_y)) tabd
 10     ON taba.pk = tabd.pk

 11 /

This SQL....I have a hard time "visualize" it How is TABLE(...) tabd derived/evaluated ? Most importantly: How are the function parameters determined ? (func returns a nested table of objects)

Is "TABLE(...)" evaluated AFTER the OTHER tables are joined & ON clauses applied
?

thanks Received on Tue Oct 10 2006 - 10:10:50 CDT