ROWID

Translation spec for ROWID pseudocolumn

Description

For each row in the database, the ROWID pseudocolumn returns the address of the row. (Oracle SQL Language Reference Rowid pseudocolumn)

Snowflake does not have an equivalent for ROWID. The pseudocolumn is transformed to NULL in order to avoid runtime errors.

ROWID

Sample Source Patterns

Oracle

IN -> Oracle_01.sql
CREATE TABLE sample_table
(
    sample_column varchar(10)
);

INSERT INTO sample_table(sample_column) VALUES ('text 1');
INSERT INTO sample_table(sample_column) VALUES ('text 2');

SELECT ROWID FROM sample_table;
SELECT MAX(ROWID) FROM sample_table;

Snowflake

OUT -> Oracle_01.sql
CREATE OR REPLACE TABLE sample_table
    (
        sample_column varchar(10)
    )
    COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
    ;

INSERT INTO sample_table (sample_column)
VALUES ('text 1');

INSERT INTO sample_table (sample_column)
VALUES ('text 2');

SELECT
ROWID FROM
sample_table;

SELECT
MAX(ROWID) FROM
sample_table;

Known Issues

No issues were found.

No related EWIs.

Last updated