Create Table
Advertisements
Create Table
Create Table statement is used for create a table in database. Tables are organized into rows and columns, and each table must have a name.
Syntax
CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... );
Example
CREATE TABLE Employee ( emp_id number(5), name varchar(20), salary number(10), );
Employee table
emp_id | name | salary |
---|---|---|
The empty table can be filled with data by using the INSERT INTO statement.
Google Advertisment