UROWID Data Type
Last updated
Last updated
Oracle uses universal rowids (urowids) to store the addresses of index-organized and foreign tables. Index-organized tables have logical urowids and foreign tables have foreign urowids.()
1. Retrieving UROWID from a table that does not have an explicit column with this data type
EWI should be displayed when trying to select UROWID column. There is a work item to add the corresponding EWI.
This issue has been marked as critical and will be fixed in the upcoming releases.
Just like , it is possible to insert data in UROWID columns if the insert has a valid UROWID, but retrieving from a table is not allowed (see ).
The following query displays an error in Snowflake since hr.countries do not contain a ROWID (as mentioned in UROWID is accessed with SELECT
... ROWID
statement) column.
: Data type converted to another data type.
: ROWID pseudocolumn is not supported in Snowflake.