Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database

Executing queries using SQL plus on Oracle database, Oracle12c Tutorial / By
Executing INSERT statements in SQL plus

The insert statement is used to insert data in the Oracle database through the SQL INSERT command.

  • Fig 7.2

The above figure shows the INSERT command being executed where the table is specified along with the values to be inserted in the table.

Here in the table Students the values inserted are the name ,id and the city’s name as shown in Fig 7.3

  • Fig 7.3

The above figure shows that in the table students the row is created with the values specified.