ROWID value in SELECT statement | Code Factory

Code Factory

·

Follow

1 min read

·

Apr 2, 2020

--

Listen

Share

Reference Link : Link

Donate Link : Link

CREATE TABLE EMP (
 EMP_CODE number(5),
 EMP_NAME varchar2(25),
 EMP_AGE number(5)
);insert into emp(emp_code, emp_name, emp_age) values(101, 'JAN', 1);
insert into emp(emp_code, emp_name, emp_age) values(102, 'FEB', 2);
insert into emp(emp_code, emp_name, emp_age) values(103, 'MAR', 3);
insert into emp(emp_code, emp_name, emp_age) values(104, 'APR', 4);
insert into emp(emp_code, emp_name, emp_age) values(105, 'MAY', 5);

select rowid, emp_code, emp_name, emp_age from emp where rowid = 'AAs7znAAkAAAAqDAAA';select rowid, ORA_ROWSCN, emp_code, emp_name, emp_age from emp;