SQL Language (MOSC)

MOSC Banner

Table function?

edited Dec 17, 2015 11:44AM in SQL Language (MOSC) 3 commentsAnswered ✓

I've been trying to find the description of the sql TABLE function.  But, the word is so common that I haven't been able to find what I'm looking for.  Please see the select statement below.  The "FROM TABLE(..." clause is my interest.  Can someone point me to the documentation that describes the table function?  It seems like it would have a lot of uses.

SELECT PLAN_TABLE_OUTPUT

  FROM TABLE(DBMS_XPLAN.DISPLAY('MY_PLAN_TABLE', 'st1','TYPICAL'));

Thank You

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center