Oracle SQLPlus Autonumber
Posted on 2004-03-29
I'm using Oracle SQLPlus and I was wondering if there was any way of declaring a field as both a primary key and an autonumber??? I need to do this using ONLY SQL plus, not forms builder or anything else!
At the moment, the create table statement looks like:
create table customer
(CUSTID number(4) not null primary key, ..........)
so can I turn CUSTID into an autonumber here?