oracle8.1.6 begin :1 := acs.add_user( user_id => :user_id, email => :email, url => :url, authority_id => :authority_id, username => :username, first_names => :first_names, last_name => :last_name, screen_name => :screen_name, password => :hashed_password, salt => :salt, creation_user => :creation_user, creation_ip => :peeraddr, email_verified_p => :email_verified_p, member_state => :member_state ); end; begin acs.remove_user( user_id => :user_id ); end; begin person.del( person_id => :person_id ); end; select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from cc_users u where lower(nvl(u.first_names || ' ', '') || nvl(u.last_name || ' ', '') || u.email || ' ' || nvl(u.screen_name, '')) like lower('%'||:value||'%') order by name 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)