Database Reference
In-Depth Information
);
number(5) varchar(20) date,
number(6), number(7,2), number(7,2), number(6), varchar(100) PRIMARY KEY, NOT
NULL,
Exercise: Insert Following data into product_info table
Exercise: Create
Customer T
able with following structure.
Column
Customer_id
Customer_name Customer_address Customer_city
Customer_state Customer _phone
Datatype
Number Character Character Character Character Character Exercise: Create
Order T
able with following structure.
Column Datatype
Order_no Number
Order_date date
Customer_id Number
Exercise: Create OrderItem Table with following structure.
Column Datatype
Order_ no Number
Order_item Number
Product_ID Number
