SQL> show user USER is "ECONSUMER" SQL> sta GetMaxImplsUsr.sql IMPLS_USR_MAX ------------- SQL> l 1* SELECT MAX(USER_ID) IMPLS_USR_MAX FROM SKINID_INPULSE_LOG SQL> select count(*) from SKINID_INPULSE_LOG; COUNT(*) ---------- 0 SQL> show user USER is "ECONSUMER" SQL> sta SKINID_CRITERIA_REGIMEN_XREF.sql 2 / CRITERIA_ID REGIMEN_ID MATCH_FLAG ----------- ---------- ---------- 1 1 1 1 2 1 1 3 1 1 4 1 1 5 1 1 6 1 1 7 1 1 8 1 1 9 1 1 10 1 1 11 1 1 12 1 1 13 1 1 14 1 1 15 1 1 16 1 1 17 1 1 18 1 1 19 1 1 20 1 1 21 1 1 22 1 1 23 1 1 24 1 1 25 1 1 26 1 2 1 0 2 2 1 2 3 0 2 4 0 2 5 0 2 6 0 2 7 0 2 8 1 2 9 1 2 10 1 2 11 1 2 12 1 2 13 0 2 14 0 2 15 0 2 16 0 2 17 0 2 18 0 2 19 0 2 20 0 2 21 0 2 22 0 2 23 0 2 24 0 2 25 0 2 26 0 3 1 0 3 2 0 3 3 0 3 4 0 3 5 0 3 6 0 3 7 0 3 8 0 3 9 0 3 10 0 3 11 1 3 12 1 3 13 0 3 14 0 3 15 0 3 16 0 3 17 0 3 18 0 3 19 0 3 20 0 3 21 0 3 22 0 3 23 0 3 24 0 3 25 0 3 26 0 4 1 0 4 2 0 4 3 1 4 4 1 4 5 0 4 6 0 4 7 0 4 8 0 4 9 1 4 10 1 4 11 0 4 12 0 4 13 0 4 14 0 4 15 1 4 16 1 4 17 1 4 18 1 4 19 1 4 20 0 4 21 1 4 22 1 4 23 0 4 24 1 4 25 1 4 26 0 5 1 0 5 2 0 5 3 0 5 4 0 5 5 0 5 6 0 5 7 0 5 8 0 5 9 1 5 10 1 5 11 1 5 12 1 5 13 1 5 14 1 5 15 0 5 16 0 5 17 1 5 18 1 5 19 1 5 20 1 5 21 1 5 22 1 5 23 1 5 24 1 5 25 1 5 26 1 6 1 1 6 2 1 6 3 0 6 4 0 6 5 1 6 6 1 6 7 1 6 8 1 6 9 0 6 10 0 6 11 1 6 12 1 6 13 0 6 14 1 6 15 0 6 16 0 6 17 0 6 18 0 6 19 0 6 20 1 6 21 0 6 22 0 6 23 1 6 24 0 6 25 0 6 26 1 7 1 1 7 2 1 7 3 1 7 4 0 7 5 1 7 6 1 7 7 1 7 8 1 7 9 1 7 10 1 7 11 1 7 12 1 7 13 1 7 14 1 7 15 0 7 16 0 7 17 1 7 18 0 7 19 1 7 20 1 7 21 1 7 22 1 7 23 1 7 24 1 7 25 1 7 26 1 8 1 0 8 2 0 8 3 1 8 4 1 8 5 0 8 6 0 8 7 0 8 8 0 8 9 1 8 10 1 8 11 1 8 12 1 8 13 1 8 14 1 8 15 1 8 16 1 8 17 1 8 18 1 8 19 1 8 20 1 8 21 1 8 22 1 8 23 1 8 24 1 8 25 1 8 26 1 9 1 1 9 2 1 9 3 0 9 4 0 9 5 1 9 6 1 9 7 1 9 8 1 9 9 1 9 10 1 9 11 1 9 12 1 9 13 1 9 14 1 9 15 0 9 16 0 9 17 1 9 18 0 9 19 1 9 20 1 9 21 1 9 22 1 9 23 1 9 24 1 9 25 1 9 26 1 10 1 1 10 2 1 10 3 1 10 4 1 10 5 0 10 6 0 10 7 1 10 8 1 10 9 1 10 10 1 10 11 1 10 12 1 10 13 1 10 14 1 10 15 1 10 16 1 10 17 0 10 18 1 10 19 1 10 20 0 10 21 1 10 22 1 10 23 0 10 24 1 10 25 1 10 26 0 11 1 1 11 2 1 11 3 0 11 4 0 11 5 1 11 6 1 11 7 1 11 8 1 11 9 1 11 10 1 11 11 1 11 12 1 11 13 1 11 14 1 11 15 0 11 16 0 11 17 1 11 18 0 11 19 1 11 20 1 11 21 1 11 22 1 11 23 1 11 24 1 11 25 1 11 26 1 12 1 0 12 2 0 12 3 0 12 4 0 12 5 0 12 6 0 12 7 0 12 8 0 12 9 1 12 10 1 12 11 1 12 12 1 12 13 1 12 14 1 12 15 0 12 16 0 12 17 1 12 18 0 12 19 1 12 20 1 12 21 1 12 22 1 12 23 1 12 24 1 12 25 1 12 26 1 13 1 0 13 2 0 13 3 1 13 4 1 13 5 0 13 6 0 13 7 0 13 8 0 13 9 1 13 10 1 13 11 1 13 12 1 13 13 1 13 14 1 13 15 1 13 16 1 13 17 0 13 18 1 13 19 1 13 20 0 13 21 1 13 22 1 13 23 0 13 24 1 13 25 1 13 26 0 14 1 1 14 2 1 14 3 1 14 4 1 14 5 1 14 6 1 14 7 1 14 8 1 14 9 1 14 10 1 14 11 1 14 12 1 14 13 1 14 14 1 14 15 1 14 16 1 14 17 1 14 18 1 14 19 1 14 20 1 14 21 1 14 22 1 14 23 1 14 24 1 14 25 1 14 26 1 15 1 0 15 2 1 15 3 1 15 4 1 15 5 1 15 6 1 15 7 0 15 8 1 15 9 1 15 10 1 15 11 1 15 12 1 15 13 1 15 14 1 15 15 0 15 16 0 15 17 1 15 18 1 15 19 1 15 20 1 15 21 1 15 22 1 15 23 1 15 24 1 15 25 1 15 26 1 16 1 1 16 2 0 16 3 1 16 4 0 16 5 1 16 6 0 16 7 1 16 8 0 16 9 1 16 10 0 16 11 1 16 12 0 16 13 1 16 14 0 16 15 1 16 16 1 16 17 1 16 18 1 16 19 0 16 20 0 16 21 1 16 22 0 16 23 0 16 24 1 16 25 1 16 26 1 17 1 0 17 2 1 17 3 0 17 4 1 17 5 0 17 6 1 17 7 0 17 8 1 17 9 0 17 10 1 17 11 0 17 12 1 17 13 0 17 14 1 17 15 0 17 16 0 17 17 0 17 18 0 17 19 0 17 20 0 17 21 0 17 22 0 17 23 0 17 24 0 17 25 0 17 26 0 18 1 1 18 2 1 18 3 1 18 4 1 18 5 1 18 6 1 18 7 1 18 8 1 18 9 1 18 10 1 18 11 1 18 12 1 18 13 1 18 14 1 18 15 1 18 16 1 18 17 1 18 18 1 18 19 1 18 20 1 18 21 1 18 22 1 18 23 1 18 24 1 18 25 1 18 26 1 19 1 1 19 2 1 19 3 1 19 4 1 19 5 0 19 6 0 19 7 1 19 8 1 19 9 1 19 10 1 19 11 1 19 12 1 19 13 1 19 14 1 19 15 1 19 16 1 19 17 0 19 18 1 19 19 1 19 20 0 19 21 1 19 22 1 19 23 1 19 24 1 19 25 1 19 26 0 20 1 0 20 2 0 20 3 0 20 4 0 20 5 1 20 6 1 20 7 0 20 8 0 20 9 0 20 10 0 20 11 0 20 12 0 20 13 0 20 14 0 20 15 0 20 16 0 20 17 1 20 18 0 20 19 0 20 20 1 20 21 0 20 22 1 20 23 1 20 24 0 20 25 0 20 26 1 21 1 0 21 2 0 21 3 0 21 4 0 21 5 0 21 6 0 21 7 1 21 8 1 21 9 0 21 10 0 21 11 0 21 12 0 21 13 0 21 14 0 21 15 0 21 16 1 21 17 0 21 18 0 21 19 1 21 20 0 21 21 0 21 22 1 21 23 0 21 24 0 21 25 1 21 26 0 22 1 1 22 2 1 22 3 1 22 4 1 22 5 1 22 6 1 22 7 1 22 8 1 22 9 1 22 10 1 22 11 1 22 12 1 22 13 1 22 14 1 22 15 1 22 16 1 22 17 1 22 18 1 22 19 1 22 20 1 22 21 1 22 22 1 22 23 1 22 24 1 22 25 1 22 26 1 23 1 1 23 2 1 23 3 0 23 4 0 23 5 1 23 6 1 23 7 1 23 8 1 23 9 0 23 10 0 23 11 0 23 12 0 23 13 0 23 14 0 23 15 1 23 16 1 23 17 1 23 18 1 23 19 1 23 20 1 23 21 1 23 22 1 23 23 1 23 24 1 23 25 1 23 26 1 24 1 1 24 2 1 24 3 1 24 4 1 24 5 0 24 6 0 24 7 1 24 8 1 24 9 1 24 10 1 24 11 1 24 12 1 24 13 1 24 14 1 24 15 1 24 16 1 24 17 0 24 18 1 24 19 1 24 20 0 24 21 1 24 22 1 24 23 0 24 24 1 24 25 1 24 26 0 25 1 1 25 2 0 25 3 1 25 4 0 25 5 1 25 6 0 25 7 1 25 8 0 25 9 1 25 10 0 25 11 1 25 12 0 25 13 1 25 14 0 25 15 1 25 16 1 25 17 1 25 18 1 25 19 1 25 20 1 25 21 1 25 22 1 25 23 1 25 24 1 25 25 1 25 26 1 26 1 0 26 2 1 26 3 0 26 4 1 26 5 0 26 6 1 26 7 0 26 8 1 26 9 0 26 10 1 26 11 0 26 12 1 26 13 0 26 14 1 26 15 0 26 16 0 26 17 0 26 18 0 26 19 0 26 20 0 26 21 0 26 22 0 26 23 0 26 24 0 26 25 0 26 26 0 27 1 1 27 2 1 27 3 1 27 4 1 27 5 1 27 6 1 27 7 1 27 8 1 27 9 1 27 10 1 27 11 1 27 12 1 27 13 1 27 14 1 27 15 1 27 16 1 27 17 1 27 18 1 27 19 1 27 20 1 27 21 1 27 22 1 27 23 1 27 24 1 27 25 1 27 26 1 28 1 1 28 2 1 28 3 1 28 4 1 28 5 1 28 6 1 28 7 1 28 8 1 28 9 1 28 10 1 28 11 1 28 12 1 28 13 1 28 14 1 28 15 1 28 16 1 28 17 1 28 18 1 28 19 1 28 20 1 28 21 1 28 22 1 28 23 1 28 24 1 28 25 1 28 26 1 1 30 1 2 30 1 3 30 1 4 30 1 5 30 1 6 30 1 7 30 1 8 30 1 9 30 1 10 30 1 11 30 1 12 30 1 13 30 1 14 30 1 15 30 1 16 30 1 17 30 1 18 30 1 19 30 1 20 30 1 21 30 1 22 30 1 23 30 1 24 30 1 25 30 1 26 30 1 27 30 1 28 30 1 1 31 1 2 31 1 3 31 1 4 31 1 5 31 1 6 31 1 7 31 1 8 31 1 9 31 1 10 31 1 11 31 1 12 31 1 13 31 1 14 31 1 15 31 1 16 31 1 17 31 1 18 31 1 19 31 1 20 31 1 21 31 1 22 31 1 23 31 1 24 31 1 25 31 1 26 31 1 27 31 1 28 31 1 1 32 1 2 32 1 3 32 1 4 32 1 5 32 1 6 32 1 7 32 1 8 32 1 9 32 1 10 32 1 11 32 1 12 32 1 13 32 1 14 32 1 15 32 1 16 32 1 17 32 1 18 32 1 19 32 1 20 32 1 21 32 1 22 32 1 23 32 1 24 32 1 25 32 1 26 32 1 27 32 1 28 32 1 1 33 1 2 33 1 3 33 1 4 33 1 5 33 1 6 33 1 7 33 1 8 33 1 9 33 1 10 33 1 11 33 1 12 33 1 13 33 1 14 33 1 15 33 1 16 33 1 17 33 1 18 33 1 19 33 1 20 33 1 21 33 1 22 33 1 23 33 1 24 33 1 25 33 1 26 33 1 27 33 1 28 33 1 1 29 1 2 29 1 3 29 1 4 29 1 5 29 1 6 29 1 7 29 1 8 29 1 9 29 1 10 29 1 11 29 1 12 29 1 13 29 1 14 29 1 15 29 1 16 29 1 17 29 1 18 29 1 19 29 1 20 29 1 21 29 1 22 29 1 23 29 1 24 29 1 25 29 1 26 29 1 27 29 1 28 29 1 1 34 1 2 34 1 3 34 1 4 34 1 5 34 1 6 34 1 7 34 1 8 34 1 9 34 1 10 34 1 11 34 1 12 34 1 13 34 1 14 34 1 15 34 1 16 34 1 17 34 1 18 34 1 19 34 1 20 34 1 21 34 1 22 34 1 23 34 1 24 34 1 25 34 1 26 34 1 27 34 1 28 34 1 1 35 1 2 35 1 3 35 1 4 35 1 5 35 1 6 35 1 7 35 1 8 35 1 9 35 1 10 35 1 11 35 1 12 35 1 13 35 1 14 35 1 15 35 1 16 35 1 17 35 1 18 35 1 19 35 1 20 35 1 21 35 1 22 35 1 23 35 1 24 35 1 25 35 1 26 35 1 27 35 1 28 35 1 924 rows selected. SQL> sta SKINID_CRITERIA_REGIMEN_XREF_CNT.sql SQL> / COUNT(1) ---------- 924 SQL> sta skinid_regimen_update.sql 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. 1 row updated. Commit complete.