Test Your Understanding 1 in sql

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:

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

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program

Sharing Is Caring