oracle8.1.6 begin acs.remove_user( user_id => :user_id ); end; begin person.del( person_id => :person_id ); end; select user_id, username, authority_id, first_names, last_name, first_names || ' ' || last_name as name, email, url, screen_name, priv_name, priv_email, email_verified_p, email_bouncing_p, no_alerts_until, last_visit, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, second_to_last_visit, to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, n_sessions, password_question, password_answer, password_changed_date, member_state, rel_id, trunc(sysdate - password_changed_date) as password_age_days, creation_date, creation_ip from cc_users where user_id = :user_id select user_id, username, authority_id, first_names, last_name, first_names || ' ' || last_name as name, email, url, screen_name, priv_name, priv_email, email_verified_p, email_bouncing_p, no_alerts_until, last_visit, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, second_to_last_visit, to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, n_sessions, password_question, password_answer, password_changed_date, member_state, rel_id, trunc(sysdate - password_changed_date) as password_age_days, creation_date, creation_ip from cc_users where authority_id = :authority_id and lower(username) = lower(:username)