Oracle Create Table - oracle tutorial - sql tutorial




How to create table statement in oracle ?

  • In Oracle, CREATE TABLE statement is used to create a new table in the database.
  • To create a table, you have to name that table and define its columns and datatype for each column.

Syntax:

CREATE TABLE table_name
( 
  			column1 datatype [ NULL | NOT NULL ],
 			 column2 datatype [ NULL | NOT NULL ],
  ...
  column_n datatype [ NULL | NOT NULL ]
); 
click below button to copy the code. By - oracle tutorial - team

Parameters used in syntax

  • table_name: It specifies the name of the table which you want to create.
  • column1, column2, ... column n: It specifies the columns which you want to add in the table. Every column must have a datatype. Every column should either be defined as "NULL" or "NOT NULL". In the case, the value is left blank; it is treated as "NULL" as default.
Oracle create table

SQL Create Table

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Oracle CREATE TABLE Example

  • Here we are creating a table named customers. This table doesn't have any primary key.
Oracle create table no null

Learn oracle - oracle tutorial - Oracle create table no null - oracle examples - oracle programs

CREATE TABLE customers
( customer_id number(10) NOT NULL,
  			customer_name varchar2(50) NOT NULL,
  city varchar2(50)
); 
click below button to copy the code. By - oracle tutorial - team
  • This table contains three columns
    • customer_id: It is the first column created as a number datatype (maximum 10 digits in length) and cannot contain null values.
    • customer_name: it is the second column created as a varchar2 datatype (50 maximum characters in length) and cannot contain null values.
    • city: This is the third column created as a varchar2 datatype. It can contain null values.
Oracle create table with primary key

Learn oracle - oracle tutorial - Oracle create table with primary key - oracle examples - oracle programs

Oracle CREATE TABLE Example with primary key

CREATE TABLE customers
( customer_id number(10) NOT NULL,
  customer_name varchar2(50) NOT NULL,
  city varchar2(50),
 			 CONSTRAINT customers_pk PRIMARY KEY (customer_id)
);
click below button to copy the code. By - oracle tutorial - team

What is Primary key

  • A primary key is a single field or combination of fields that contains a unique record. It must be filled.
  • None of the field of primary key can contain a null value. A table can have only one primary key.
    • In Oracle, total number of columns cannot be more than 32.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle Create Table

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×