![oracle - How can I set auto increment of a primary key in the table in SQL DEVELOPER? - Stack Overflow oracle - How can I set auto increment of a primary key in the table in SQL DEVELOPER? - Stack Overflow](https://i.stack.imgur.com/38PPg.png)
oracle - How can I set auto increment of a primary key in the table in SQL DEVELOPER? - Stack Overflow
![SOLVED: CREATE TABLE promotion (gift VARCHAR2(15) PRIMARY KEY, minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); ALTER TABLE promotion ADD PRIMARY KEY(gift); Structure of the PROMOTION table Oracle SQLPlus Name Null? Type GIFT VARCHAR2(15) SOLVED: CREATE TABLE promotion (gift VARCHAR2(15) PRIMARY KEY, minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); ALTER TABLE promotion ADD PRIMARY KEY(gift); Structure of the PROMOTION table Oracle SQLPlus Name Null? Type GIFT VARCHAR2(15)](https://cdn.numerade.com/ask_images/1770abb0f29a4cb3a2639d6ce76b7de4.jpg)
SOLVED: CREATE TABLE promotion (gift VARCHAR2(15) PRIMARY KEY, minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); ALTER TABLE promotion ADD PRIMARY KEY(gift); Structure of the PROMOTION table Oracle SQLPlus Name Null? Type GIFT VARCHAR2(15)
![postgresql - Different behaviour between oracle and postgres regarding alter table primary key command - Database Administrators Stack Exchange postgresql - Different behaviour between oracle and postgres regarding alter table primary key command - Database Administrators Stack Exchange](https://i.stack.imgur.com/eF5qO.png)