Oracle Application Express (MOSC)

MOSC Banner

Interactive grid removes spaces

Look at the query and result generated in sqlplus :

select plan_line_id , lpad(a.plan_operation||' '||a.plan_options, length(a.plan_operation||' '||a.plan_options)+a.plan_depth*3) OPERATION, a.plan_cost COST, output_rows "ROWS"

 from gV$SQL_PLAN_MONITOR a

 where sql_id ='8gan9d0z7bzhm'


looks pretty cool ;)


And the same result in grid report :

Apex 21 removes all spaces generated by lpad function. The same problem is with classic report and classic grid :( any idea why ?


K.

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