CREATE TABLE in Oracle SQL Simple version
Simple table creation in Oracle SQL
- This DDL statement creates a table with n attributes. This is the simplest of table creation.
- Some of the basic data types are CHAR, VARCHAR, DATE, and NUMBER.
- Remember that DDL statement will update the Data Dictionary.
- This statement will create the table FURNITURES with the following attributes;
- FURNITURE_ID - character attribute stores alpha-numeric characters,
- FURNITURE_NAME - variable length character attribute stores alpha-numeric characters,
- MANUFACTURER - variable length character attribute stores alpha-numeric characters and
- QUANTITY - number attribute stores numbers only.
- Each record that will be stored in this table will occupy maximum of 60 bytes (Furniture_id 5 bytes + Furniture_name 25 bytes + Manufacturer 25 bytes + Quantity 5 bytes = 60 bytes).
- The details regarding the names of the table and its attributes, types of the attributes and size of the attributes all will be stored in the data dictionary. [Note: for MySQL the data dictionary is called Information schema and for Oracle database it is Oracle metadata]
- This statement will not include any additional constraints other than data type and size.