Be careful about your use of Oracle-specific data types like
UROWID. They might offer a slight improvement in
performance over other means of identifying a single row (primary key or unique index value), but that is by no means guaranteed.
On the other hand, the use of
UROWID means that your SQL statement will not be portable to other SQL databases.
Further, many developers are not familiar with these data types, which can make the code harder to maintain.
Noncompliant Code Example
SET SERVEROUTPUT ON
id rowid; -- Non-Compliant
universeId urowid; -- Non-Compliant
SELECT rowid INTO id FROM DUAL;
SELECT rowid INTO universeId FROM DUAL;
DBMS_OUTPUT.PUT_LINE('id = ' || id);
DBMS_OUTPUT.PUT_LINE('universe id = ' || universeId);