Search code examples
oraclesqlplussql-execution-plan

How to format the explain plan output in sqlplus

I believe, Question is self-explanatory. The explain plan out table in sqlplus, Looks collapsed. It is hard to interpret each line. I tried to set the linesize but it does not work. Can you able provide any suggestion to format the output?

Solution: As I am using CMD. I just adjust the width of CMD and set line size to 132 in sqlplus. It worked as I expected.

Thanks guys

Solution

  • you can use

    set linesize value_size

    enter image description here