Incorrect column order in the sessions window

[mkm]

My query for active sessions return columns in order:
N
USERNAME
SES
SERIAL#
SERVICE_NAME
...

But in sessions window i see other order
USERNAME
SID
SERIAL#
OSUSER
...

why?

plsql developer 13.0.6.1911

 

[Marco Kalter]

If the session query starts with "select *" then the Session Window will implicitly move the identifying columns to the front, so that you can easily identify a session. If you explicitly select specific columns, this reordering will not occur.

 

[mkm]

It's a bug, my query use pipelined function, because the request is complex, it's easier to propagate changes to projects.

select *
from table(PlsqlDeveloperPkg.ActiveSessions)

Please, do so, at least if the request uses v$session

 

[Marco Kalter]

We'll enhance this. As a workaround you can specify:

select s.*
from table(PlsqlDeveloperPkg.ActiveSessions) s