Using ROWID

 

Using ROWID is another way to have the system assign a unique value to a column. ROWID is similar to identity columns. But rather than being an attribute of a numeric column, it is a separate data type.

To create a table similar to the identity column example:

CREATE TABLE ORDERS    (ORDERNO ROWID    GENERATED ALWAYS,
   SHIPPED_TO VARCHAR (36) ,
   ORDER_DATE DATE)

 

Parent topic:

Data definition language