sqlplus user/passwort@database @partition_dict_queries.sql

generate_batch ()
{
export DBO=
export DBOPW=
export ORACLE_SID=

sqlplus -S $DBO/$DBOPW@$ORACLE_SID <<EOF > /.../batchrun.$(/bin/date '+%d%m%Y.%Hh')

set echo Off
set term On
set pages 0
set head off
set ver off
set feed off
set trims on
set linesize 20000

WITH data
        AS (SELECT user_id,
                   jc_name,
                   upd_time,
                   RANK () OVER (PARTITION BY user_id ORDER BY upd_time ASC)
                      rk
              FROM user_jc
             WHERE user_id IN (  SELECT user_id
                                   FROM user_jc
                                  WHERE JC_NAME LIKE 'TTMR\_S\_%' ESCAPE '\'
                               GROUP BY user_id
                                 HAVING COUNT (user_id) > 1)
                   AND JC_NAME LIKE 'TTMR\_S\_%' ESCAPE '\')
SELECT    'DISCONNECT ent_user  FROM job_code WITH user_id = "'
       || user_id
       || '", jc_name = "'
       || jc_name
       || '";'
  FROM data
 WHERE rk = 1;

exit
EOF
}