ROWID

• MySQL

調べた限りなし

• Oracle

(19)

drop table tab1 purge;
create table tab1(col1 int);
insert into tab1 values(1);
insert into tab1 values(2);
commit;

select rowid,col1 from tab1;

select col1,rowid, DBMS_ROWID.ROWID_RELATIVE_FNO(rowid) from tab1;
select col1,rowid, DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from tab1;
select col1,rowid, DBMS_ROWID.ROWID_ROW_NUMBER (rowid) from tab1;
select col1,rowid, DBMS_ROWID.ROWID_OBJECT(rowid) from tab1;

 

• PostgreSQL

(13)

drop table tab1;
create table tab1(col1 int);
insert into tab1 values(1);
insert into tab1 values(2);

select ctid,col1 from tab1;

 

• SQL Server

調べた限りなし