If you want to copy all rows from the source table to the target table, you remove the WHERE clause. Otherwise, you can specify which rows from the source table should be copied to the target table. The Oracle INSERT statement is used to insert a single record or multiple records into a table in Oracle.
The Complete Guide to the Oracle INSERT INTO The Oracle INSERT INTO statement is one of the most popular commands in Oracle, and its one of the first commands you learn to use. Each expression in the WHEN condition must refer to columns returned by the select list of the subquery. How to Insert a DateTime Value into an Oracle This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.
INSERT - Oracle SQL oracle select dml update insert sql merge ( upsert : update insert ) dml ( insert: ). Read how to insert data and how to use the full functionality of the INSERT statement in this guide. Another (usually short) name for the referenced table or view. Storing dates and times inside a DATE field is a good practice to get into.