CONNECT TO SAMPLE;
--SET CURRENT SCHEMA = '????????';
--
  INSERT INTO EMPLOYEE
           ( EMPNO
           , FIRSTNME
           , MIDINIT
           , LASTNAME
           , EDLEVEL
           , SEX
           , BIRTHDATE
           , HIREDATE
           , SALARY)
    VALUES ( '??????'
           , 'first'
           , 'm'
           , 'last'
           , 99
           , '?'
           , 'yyyy-mm-dd'
           , CURRENT DATE
           , 9999999.99);
  COMMIT;
--
  UPDATE EMPLOYEE
    SET SALARY = SALARY * 1.1
      , BONUS = SALARY * .5
    WHERE EMPNO = '??????';
  COMMIT;
--
  SELECT *
    FROM EMPLOYEE
    WHERE EMPNO = '??????';
--
  CONNECT RESET;