SQL Performance (MOSC)

MOSC Banner

Explain plan works in sqlplus but not in pl/sql

edited May 26, 2015 10:07AM in SQL Performance (MOSC) 3 commentsAnswered

Explain plan works in sqlplus:

SQL> explain plan set statement_id = '1ng6v39qb5hxg' into my_plan_table for /*
  2    The name + type results of these queries will be used by the Code Assistant
  3    if the "Describe Context" option is enabled. After typing 3 or more characters
  4    the Code Assistant will show a list of matching names.
  5    Separate multiple queries with semi-colons and use the :schema bind variable
  6    to restrict names to the currently connected user.
  7    In case of an error the query results will be omitted. No error message will
  8    be displayed.
  9    Place this file in the PL/SQL Developer installation directory for all users,

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