P E N C I L
Login

SQL - Oracle

  1. Date
    alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
    select sysdate+1/86400 from dual;
  2. insert into mytable select SEQ$TRADABLE_STOCKS$ID.nextval, .... from table where <query>; 
  3. insert into mytable(id, a) values (seq.nextval, 'xx')
    Note that we cannot use double quote for string