Rules for creating a table

Rules for creating a table

• Table names & column names must begin with a letter and be 1–30 characters.
• Table names must begin with a character A–Z or a–z.
• Names may contain characters, numerals and special characters like A–Z, a–z,0–9, _ (underscore), $, and # (legal characters, but their use is discouraged).
• The name must not be same as the name of any other object in your schema.
• Names must not be an Oracle Server reserved word.
• Table names are not case sensitive. If you create a table with upper, lower or a mixed case the table’s names are stored only the upper case in the data dictionary.
• If you want to create a table with the name in lower case characters, then you must enclose the table name within double quotes while creating the table.
• The no of columns in a table can be up to a maximum of 1000.
• The column names in the table must be unique. However, column names can be duplicated across tables.

Syntax:

CREATE TABLE [schema.]
(
  [DEFAULT ] [,…..]
);

Example:

CREATE TABLE dept
(
deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13)
);