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