#!/bin/sh
table_name='v$session'
sql_select="select username from $table_name where username is not null;"
set_format='set newpage none
            set feed off
            set line 1000
            set trims on'

(
    echo "conn / as sysdba"
    echo "${set_format}"
    echo "${sql_select}"
) | sqlplus -s /nolog