Sample Header Ad - 728x90

See content of temporary Table in Oracles' EXPLAIN

1 vote
1 answer
250 views
I'm executing a Query in Oracle SQL Developer and eventually call
SELECT * FROM TABLE ( dbms_xplan.display );
to get an impression what Oracle just did. There's a column *Name* in the output that states the name of the index that is used in an operation or the name of the table that is being accessed. Every once in a while it says something like *SYS_TEMP_0FD9D6B47_384FBF5*. I'm not sure what of make of it. I guess this is a temporary table created from a WITH clause. How can I see what's the content or the SQL code behind this table?
Asked by Bernhard Döbler (217 rep)
Oct 16, 2020, 04:55 PM
Last activity: May 28, 2025, 01:05 PM