ROWID value in SELECT statement | Code Factory


Donate : Link

Medium Blog : Link

Applications : 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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s