ROWID value in SELECT statement | Code Factory

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;

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Salesforce Data Migration Checklist for 2021 | RT Labs

Docker Containers — Basic to Advance

Simulation for robot development

Topological Sort(Kahn’s Algorithm)

CSS3 Responsive Icons

Software Economics

How to Auto-Sync WooCommerce Products to Google Merchant Shop Using WPFM.

My first integration of an api

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
Code Factory

Code Factory

More from Medium

How to Use AWS Parameter Store

Multi-tenant deployments with Camunda BPM and SpringBoot

Symbolic image für multi-tenancy

Design Patterns 02 — Prototype Design Pattern

How to build robust microservices