Select Code to Download

SELECT * FROM ACS.USERS WHERE group_name = 'Full Network Access' AND u
+pdate_timestamp > sysdate-24/24

SELECT user_id FROM ACS.USERS WHERE group_name = 'Full Network Access'
+ AND TO_CHAR(update_timestamp) LIKE '15-JUN-2010%'

select * from users where group_name = 'Full Network Access' and updat
+e_timestamp like sysdate
select * from users where group_name = 'Full Network Access' and updat
+e_timestamp like '14-JUN-10'

#!/usr/local/perl510/bin/perl

...
    exit 0;
    }

> ./show_db_error --test 1
$sql[1]=SELECT user_id FROM ACS.USERS WHERE group_name = 'Full Network
+ Access' AND update_timestamp LIKE sysdate
...
> ./show_db_error --test 7
$sql[1]=SELECT user_id FROM ACS.USERS WHERE group_name = 'Full Network
+ Access' AND update_timestamp LIKE '14-JUN-10'
$full_network_access = [];