ROWID value in SELECT statement | Code Factory

Reference 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;

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store