how to insert data in oracle sql || learn oracle sql tutorial 12

in this video i will show you how to insert data in oracle for more detail join our facebook group ,https://www.facebook.com/groups/242999206136244/

his Oracle tutorial explains how to use the Oracle INSERT statement with syntax and examples. We've also added some practice exercises that you can try for yourself.

Description

The Oracle INSERT statement is used to insert a single record or multiple records into a table in Oracle.

Syntax

The syntax for the Oracle INSERT statement when inserting a single record using the VALUES keyword :

Parameters or Arguments

table
The table to insert the records into.
column1, column2, ... column_n
The columns in the table to insert values.
expression1, expression2, ... expression_n
The values to assign to the columns in the table. So column1 would be assigned the value of expression1, column2 would be assigned the value of expression2, and so on.
source_table
The source table when inserting data from another table.
WHERE conditions
Optional. The conditions that must be met for the records to be inserted.
Note

When inserting records into a table using the Oracle INSERT statement, you must provide a value for every NOT NULL column.
You can omit a column from the Oracle INSERT statement if the column allows NULL values.

.----------------------------------------------------------------------------------------------------------.
video courses- list of playlist :

tips and trics
link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2

command prompt commands:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL

oracle sql:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO-

c programming:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf

.-----------------------------------------------------------------------------------------------------------.
watch more videos:

learn oracle sql online overview tutorail :
https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s

how to fix or repair a corrupted usb flash drive or cd card using command prompt:
https://www.youtube.com/edit?video_id...

how to copy a folder using cmd:
https://www.youtube.com/watch?v=Lblhb...

how to move a folder using cmd:
https://www.youtube.com/watch?v=YFfHZ...

how to dell files in cmd:
https://www.youtube.com/watch?v=3-lqg...


how to make and remove directory:
https://www.youtube.com/edit?video_id...

how to change color and title in cmd:
https://www.youtube.com/edit?video_id...

how to change directory in command prompt:
https://www.youtube.com/watch?v=SmLYx...
.-----------------------------------------------------------------------------------------------------------.
social media links:
join our group:
► https://www.facebook.com/groups/24299...

► Follow on Google+: http://[email protected]

► Follow on Twitter: https://twitter.com/@rananavi4766669 :