Help for this page

Select Code to Download


  1. or download this
    my $sql = qq {
        select SID,SERIAL,USERNAME,STATUS,SCHEMANAME,OSUSER,
        PROCESS,MACHINE,TERMINAL,PROGRAM,TYPE,MODULE,
        to_char(LOGON_TIME,'DD-MON-YY HH24:MI:SS')"LOGON_TIME",
        STATE,SERVICE_NAME from v\$session order by LOGON_TIME DESC};
    
  2. or download this
    my $sql = q {
        select SID,SERIAL,USERNAME,STATUS,SCHEMANAME,OSUSER,
        PROCESS,MACHINE,TERMINAL,PROGRAM,TYPE,MODULE,
        to_char(LOGON_TIME,'DD-MON-YY HH24:MI:SS')"LOGON_TIME",
        STATE,SERVICE_NAME from v$session order by LOGON_TIME DESC};