1 Reply Latest reply: Apr 12, 2013 4:50 PM by Gary Graham-Oracle RSS

    PLSQL output and format challenge

    798991
      Folks,
      not sure somebody run into this and found solution.
      when you run sql that's giving output from table function. Output loses the formatting.
      e.g.
      SELECT plan_table_output FROM TABLE(dbms_xplan.display_awr(+'<sql_id'...other parameters+));

      if i run this on sqlplus with "col plan_table_output format a180" it comes up as nice tablular output. with SQL developer, all fields jumbes up.

      thanks
      Ken