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 NAME DATATYPE SIZE CONSTRAINT
prod_id number 4 Primary key
prod_name varchar2 25  
Prod_expiry_date date   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

Leave a Comment

Scroll to Top