where rowid = dbms_rowid.rowid_create(1,49627,7,138,0) : dbms_rowid « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. dbms_rowid

where rowid = dbms_rowid.rowid_create(1,49627,7,138,0)

 
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.

   
  

Related examples in the same category