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 database program | relational database management system software | rdbms lab programs | rdbms lab programs pdf | dbms programs | database management software | database management system software | examples of database software| list of database applications | database system applications | examples of database | application database application software | database management application
ConversionConversion EmoticonEmoticon