ORACLE - Create Table | Document

You see, wire telegraph is a kind of a very, very long cat. You pull his
tail in New York and his head is meowing in Los Angeles. Do you understand
this? And radio operates exactly the same way: you send signals here, they
receive them there. The only difference is that there is no cat.

— Albert Einstein

ORACLE - Create Table

Tue, 11/30/2010 - 17:41 |

Juraj Maslik

CREATE TABLE in oracle..
To accomplish this task we would use one of the available ORACLE client applications such as SQL*Plus or ORACLE SQL Developer which becomes standard applications with ORACLE 11G.
First of all we need to create session or log on-to ORACLE Instance.
We can do this if we have valid ORACLE user with granted system SESSION privilege.

CREATE TABLE statement

ORACLE - Create Table

This way we just created table which have already specified some default values and some not null constraints.
If we want to add more constraints we can accomplish this using ADD clause of ALTER TABLE statement.

ORACLE - Create Table