Question

Create the following table items.

Column name	Data type	Size	Constrain
Itemno	Number	3	Primary key
Iname	Varchar	15
Price	Number	10,2
Quantity	Number	3

Answer 1

CREATE TABLE items (
    Itemno NUMERIC(3) PRIMARY KEY,
    Iname VARCHAR(15),
    Price NUMERIC(10, 2),
    Quantity NUMERIC(3)
);