oracle8.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 insert into sec_session_properties (session_id, module, property_name, property_value, property_clob, secure_p, last_hit) values ( :session_id, :module, :name, null, empty_clob(), :secure, :last_hit ) returning property_clob into :1