Shell Programming and Scripting

dbms_output.put_line("COUNTRY_CODE"||"        "||"SUB_TYPE"||"        "||"DAEMON_TYPE"||"        "||"SUB_COUNT");

    echo "COUNTRY_CODE"||"        "||"SUB_TYPE"||"        "||"DAEMON_TYPE"||"        "||"SUB_COUNT";

$ echo "a b c d"
a b c d

SQL> select /*ordered*/ distinct b.country_abbrev as country_code,DECODE(a.auto,                                                                                        'Y','DAEMON','L','LAUNCH') as sub_type,
  2          DECODE(in_use_userid,'NONE','NOT PICKED','ES','MF DAEMON','UNIX'                                                                                        ,'UNIX') AS DAEMON_TYPE,count(a.sub_idx) as sub_count
  3          FROM
  4          subiv_log a,
  5          country b
  6                  where a.sub_status_idx in (1,22,401,9)
  7                  and a.locked = 'Y'
  8                  and a.queue_flag = 'Y'
  9                  and a.auto in ('Y','L')
 10                  and a.country_idx = b.country_idx
 11          GROUP BY B.country_abbrev,A.AUTO,DECODE(in_use_userid,'NONE','NOT P                                                                                        ICKED','ES','MF DAEMON','UNIX','UNIX')
 12          ORDER BY sub_count DESC,b.country_abbrev desc ;
COUNTRY_CO SUB_TY DAEMON_TYP  SUB_COUNT
---------- ------ ---------- ----------
UK         DAEMON UNIX                7

 
 cursor sub_cur is
        select /*ordered*/ distinct b.country_abbrev as country_code,DECODE(a.auto,'Y','DAEMON','L','LAUNCH') as sub_type,
        DECODE(in_use_userid,'NONE','NOT PICKED','ES','MF DAEMON','UNIX','UNIX') AS DAEMON_TYPE,count(a.sub_idx) as sub_count
        FROM
        subiv_log a,
        country b
                where a.sub_status_idx in (1,22,401,9)
                and a.locked = 'Y'
                and a.queue_flag = 'Y'
                and a.auto in ('Y','L')
                and a.country_idx = b.country_idx
        GROUP BY B.country_abbrev,A.AUTO,DECODE(in_use_userid,'NONE','NOT PICKED','ES','MF DAEMON','UNIX','UNIX')
        ORDER BY sub_count DESC,b.country_abbrev desc ;
 BEGIN
        dbms_output.put_line('COUNTRY_CODE'||'        '||'SUB_TYPE'||'        '||'DAEMON_TYPE'||'        '||'SUB_COUNT');

 
#!/bin/ksh

${ORACLE_HOME}/bin/sqlplus -s ${DB_CONNECTION_STRING} << EOF
SET SERVEROUTPUT ON FEEDBACK OFF;
DECLARE
        dt   DATE;
        CURSOR dt_cur is select sysdate from dual;
BEGIN
        FOR dt IN dt_cur
        LOOP
                DBMS_OUTPUT.put_line ( dt.sysdate );
        END LOOP;
END;
/
exit
EOF
  
exit 0