SQL>
SQL> CREATE TABLE EMP(
2 EMPNO NUMBER(4) NOT NULL,
3 ENAME VARCHAR2(10),
4 JOB VARCHAR2(9),
5 MGR NUMBER(4),
6 HIREDATE DATE,
7 SAL NUMBER(7, 2),
8 COMM NUMBER(7, 2),
9 DEPTNO NUMBER(2)
10 );
Table created.
SQL> update emp
2 set sal = sal * 1.1
3 where hiredate < to_date('08/SEP/1981','DD/MON/YYYY');
0 rows updated.
SQL>
SQL> select *
2 from emp
3 where rowid = dbms_rowid.rowid_create(1,49627,7,138,0);
SQL>
SQL> drop table emp;
Table dropped.