Oracle建立表和自增長主鍵

/*建立表 不帶自動標示*/
create table product
(
       pid number(15) primary key not null,
       pname varchar2(20) not null
);
commit;

insert into product(pid,pname) values(1,'美瞳');
commit;

/*清楚表記錄*/

truncate table product;
commit;

select * from Product;
/*查看錶結構*/
desc product

drop table orders;
/*建立表 帶自動標示*/
create table orders
(
       oid number(15) primary key not null,
       pname varchar2(50) not null
);
create sequence oid_id start with 001001 cache 2;/*建立自動標示序列*/

insert into orders(oid,pname) values(oid_id.nextval,'美瞳');
commit;