03-AUG-10> set pages 0
03-AUG-10> set heading on
03-AUG-10> select count(*) numberofrows
 2    from iceberg_mig_acnts_stage2 s2, tvp109workorder t109
  3   where s2.no_account = t109.no_account
  4     and s2.no_property = t109.no_property
  5     and s2.no_legal_entity = t109.no_legal_entity
  6     and T109.ST_WORK_ORDER <> 'CA'
  7     and T109.IND_WORK_COMPLETED <> 'Y'
  8     and t109.tp_work_order in ('AB','AA','AN','OF','DN','DU',
  9     'IN','MC','MS','NC','ON','RC','SR')
 10     and t109.st_work_order in ('OP', 'PR', 'W ');
           0

ind> select 'SRIRAM' FIRST,'MICHEL' SECOND,'BLACKSWAN' THIRD from dual;

FIRST  SECOND THIRD
------ ------ ---------
SRIRAM MICHEL BLACKSWAN

1 row selected.

ind> set pages 0
ind> select 'SRIRAM' FIRST,'MICHEL' SECOND,'BLACKSWAN' THIRD from dual;
SRIRAM MICHEL BLACKSWAN

1 row selected.

set pages 0