All Notes on BCA

create table product
    (
    prod_no varchar2(6) primary key,
    description varchar2(20),
    unit_price number(4),
    qty_on_hand number(4),
    category varchar2(10)
    );

Same table other format

 create table product_t5
     (
     prod_no varchar2(6),
     CONSTRAINT  prod_no_pk_t5 PRIMARY KEY(prod_no),
     description varchar2(20),
     unit_price number(4),
     qty_on_hand number(4),
     category varchar2(10)
     );

insert into product_t5 values('0001','xxx','3000','4','A');
insert into product_t5 values('0002','xxx','2000','1','B');
insert into product_t5 values('0003','yyy','1500','3','A');
insert into product_t5 values('0004','zzz','2300','2','C');
insert into product_t5 values('0005','aaa','500','2','C');

select *from product;

OUTPUT: