The Oracle INSERT INTO statement permit you to insert one or multiple records into a database table.
To insert the record into the table, use the following syntax:
To insert the record for all the fields into the table, use the following syntax:
Note:
In the above example, we have inserted new record into the table called "tblCustomerLoan".
It is mandatory to specify field names. To insert the partial fields into the table, use the following syntax:
Note:
In the above example, we inserted partial record into the table called "tblCustomerLoan".
To insert multiple records into the table, use the following syntax:
Note:
In the above example, we inserted multiple records into the table called "tblCustomerLoan".