Create tables and auto-increment primary keys in Oracle

/* Create a table without automatic identification */
Create Table Product
(
PID Number (15) primary key not null,
Pname varchar2 (20) not null
);
Commit;

Insert into product (PID, pname) values (1, 'mydrian ');
Commit;

/* Clear table records */

Truncate table product;
Commit;

Select * from product;
/* View the table structure */
Desc Product

Drop table orders;
/* Create a table with automatic identification */
Create Table orders
(
Oid number (15) primary key not null,
Pname varchar2 (50) not null
);
Create sequence oid_id start with 001001 cache 2;/* Create an auto-labeled sequence */

Insert into orders (OID, pname) values (oid_id.nextval, 'mydrian ');
Commit;