Database Reference
In-Depth Information
varchar2(15) varchar2(15) varchar2(50), char(15),
char(13)
PRIMARY KEY, NOT NULL,
NOT NULL, NOT NULL,
NOT NULL,
Example : Create a table
product_info
with Primary Key and NOT NULL Constraints as
per following structure:
Column Name
Product_ID
Product_Name Date_of_purchase Qty_on_hand Cost_price
Sell_price
Reorder_limit Specification
Data Type
Number
Character Date
Number
Number
Number
Number
Character
Size Constraint
5 PRIMARY KEY
20 NOT NULL
6
7,2
7,2
6
100 Sol:
CREATE TABLE product_info (
Product_ID
Product_Name Date_of_purchase Qty_on_hand Cost_price
Sell_price
Reorder_limit Specification
