Oracle not null - oracle tutorial - sql tutorial

Learn oracle - oracle tutorial - Oracle not null - oracle examples - oracle programs

CREATE TABLE table_name
(
table_id INT NOT NULL
)

CREATE TABLE wikitechypm
(
Pm_Id int NOT NULL,
Pm_name varchar(20)
)

1. CREATE TABLE statement is used to create a new table in oracle database and ‘wikitechypm’ is the created table name.
2. In this statement, NOT NULL constraint is used and applied for pm_Id column.
3. After that click on the RUN button for executing the queries
4. After clicking the run button, the table has been created successfully

1. INSERT statement is used for inserting the required values in the created columns in the table
2. After that click on the RUN button for executing the queries
3. After clicking the run button, the table has been inserted successfully.

1. SELECT statement is used to select all the data from created table.
2. After that click on the RUN button for executing the queries.
3. After clicking the run button, the table has been selected successfully.