Test Your Understanding 1

Question:

Test Your Understanding 1

Refer the below schema, and modify the given query appropriately in order to create the product table.

COLUMN NAMEDATATYPESIZECONSTRAINT
prod_idnumber4Primary key
prod_namevarchar225 
Prod_expiry_datedate Not null

Code:

PRODUCT.sql

create TABLE product
 ( prod_id number(4),
  prod_name varchar(25),
  prod_expiry_date date NOT NULL,
  primary key(prod_id)
); 

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x