An Identity column auto increments on input, introduced from Oracle 12C, it’s a useful for the surrogate primary key column.
Syntax:
GENERATED [ ALWAYS | BY DEFAULT [ ON NULL ] ] AS IDENTITY [ ( identity_options ) ]
create table FAQS
(id number(10) GENERATED ALWAYS AS IDENTITY START WITH 1, faq varchar (1000));
// add a primary key constraint
ALTER TABLE FAQS
ADD PRIMARY KEY (id);