Insert query in SQL | SQL insert statement in Oracle

Insert query in SQL

Introduction to Oracle INSERT statement

In our previous post, we learned about how to create a table in SQL by CREATE TABLE statement. After CREATE TABLE we will learn how to INSERT INTO data in SQL table. To insert a new row into a table, you can use the Oracle INSERT statement as follows:

INSERT INTO table_name (column_list)
VALUES( value_list);

In the above statement, we can see COLUMN_LIST is the name of columns in which we wanted to insert the data. While value_list shows values that we wanted to INSERT INTO the columns of SQL table mentioned above. Also, it should be noted that every value and column name should be separated by comma.… Continue Reading