create table COLORS
(
COLOR_ID NUMBER not null,
COLOR_NAME varchar2(100) not null,
RED number not null,
GREEN number not null,
BLUE number not null,
CONSTRAINT PK_COLORS PRIMARY KEY (COLOR_ID)
)
/
--fill table-------------
insert into colors(color_id, color_name, red, green, blue) values(1, 'black', 0, 0, 0);
insert into colors(color_id, color_name, red, green, blue) values(2, 'white', 254, 254, 254);
insert into colors(color_id, color_name, red, green, blue) values(3, 'red', 254, 0, 0);
insert into colors(color_id, color_name, red, green, blue) values(4, 'green', 0, 254, 0);
insert into colors(color_id, color_name, red, green, blue) values(5, 'blue', 0, 0, 254);
insert into colors(color_id, color_name, red, green, blue) values(6, 'yellow', 0, 254, 254);
commit
/