oracle 8.1.6

update users set second_to_last_visit = last_visit, last_visit = sysdate, n_sessions = n_sessions + 1 where user_id = :user_id

select test_sql('select 1 from dual where 1=[DoubleApos $value]') from dual
select test_sql('select 1 from dual where 1=[DoubleApos "'$value'"]') from dual

insert /*+ APPEND */ into secret_tokens(token_id, token, token_timestamp) values(sec_security_token_id_seq.nextval, :random_token, sysdate)

select * from ( select token_id, token from secret_tokens sample(15) ) where rownum < :num_tokens

update sec_session_properties set property_value = null, property_clob = empty_clob(), secure_p = :secure, last_hit = :last_hit where session_id = :session_id and module = :module and property_name = :name returning property_clob into :1
update sec_session_properties set property_value = :value, property_clob = null, secure_p = :secure, last_hit = :last_hit where session_id = :session_id and module = :module and property_name = :name
update users set password = :new_password, salt = :salt, password_changed_date = sysdate where user_id = :user_id