8_Command_For_Session.sql

8_Command_For_Session.sql

undefine username

undefine sid

set long 3000

set pages 999

set verify off

col sql_text format a120

select sql_text

from V$sqltext_with_newlines

where address = (select sql_address

                 from   V$session

                 where username = upper('&&USERNAME')

                 and sid = &&SID)

ORDER BY piece

/

set verify on