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