ROWID datatype

Now there is a ROWID datatype and you don't have to put that in an char or varchar2 datatype.


1 declare
2 rowids rowid;
3 begin
4 select rowid into rowids
5 from dual;
6 dbms_output.put_line('rowid is '|| rowids);
7* end;
8 /
rowid is AAAABzAABAAAAEmAAA

PL/SQL procedure successfully completed.

SQL>