ECONSUMER@SUSASTG1> show user USER is "ECONSUMER" ECONSUMER@SUSASTG1> select * from skinid_users where user_id in(207523647,207523648) 2 ECONSUMER@SUSASTG1> / USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- PSWD_HASH -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- FAMILY_NAME -------------------------------------------------------------------------------- DOB AGE GEN --------------- ---------- --- POSTAL_CODE -------------------------------------------------------------------------------- SKINID_OPTIN NEUTROGENA_OPTIN JNJ_OPTIN MEMBER_STATUS PREV_REGIMEN_ID ------------ ---------------- ---------- ------------- --------------- LAST_REGIMEN_ID PREF_LOCALE_CD --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- CREATED_AT --------------------------------------------------------------------------- MODIFIED_AT --------------------------------------------------------------------------- CREATED_BY -------------------------------------------------------------------------------- MODIFIED_BY -------------------------------------------------------------------------------- CAMPAIGN_ID IPADDRESS ----------- ------------------------------------------------------------ SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- 207523647 raja123@dispostable.com XWwrjoKPO/QMu93aFKwa5A== raja raja 03-JUL-76 35 M 12212 1 0 0 1 en_US 29-OCT-10 09.02.00.246000 AM 5 Inpulse webservice 207523648 ramesh123@dispostable.com Zy4XE1zF5+rDzw3jOaZb2A== ramesh ramesh 03-JUL-76 36 M 12212 1 0 0 1 en_US 29-OCT-10 09.02.00.485000 AM 5 Inpulse webservice ECONSUMER@SUSASTG1> select * from skinid_inpulse_load_audit; INPULSE_LOAD_AUDIT_ID --------------------- FILE_NAME -------------------------------------------------------------------------------- CREATE_DT REC_ON_HEADER REC_PROCESSED --------------- ------------- ------------- RUN_STATUS -------------------------------------------------------------------------------- LOADED_DATE --------------- 1 inpulse_08042010.csv 04-JAN-10 2 0 Incomplete 14-SEP-10 29 inpulse_28102010.csv 04-JAN-10 2 2 Complete 28-OCT-10 21 inpulse_08042010.csv 04-JAN-10 2 2 Complete 22-OCT-10 22 inpulse_10092010.csv 09-JAN-10 0 0 Complete 22-OCT-10 23 inpulse_10102010.csv 10-JAN-10 0 0 Complete 22-OCT-10 24 inpulse_10112010.csv 11-JAN-10 1 0 Incomplete 22-OCT-10 25 inpulse_10122010.csv 12-JAN-10 0 0 Complete 22-OCT-10 26 inpulse_10132010.csv 13-JAN-10 0 0 Complete 22-OCT-10 27 inpulse_10142010.csv 14-JAN-10 1 0 Incomplete 22-OCT-10 28 inpulse_10152010.csv 15-JAN-10 4 4 Complete 22-OCT-10 41 inpulse_28102010.csv 29-JAN-10 2 2 Complete 29-OCT-10 11 rows selected. ECONSUMER@SUSASTG1> spool 0ff