SQL INSERT SELECT

Add W3Buddy as a preferred source on Google

हि En

🔊 Listen

INSERT SELECT is used to copy data from one table into another. This is very useful for data migration, backups, or transformations.

🔹 Basic Syntax

INSERT INTO target_table (col1, col2, ...)
SELECT col1, col2, ...
FROM source_table
WHERE condition;

🔹 Example

-- Copy employees from 'IT' department into backup table
INSERT INTO employees_backup (id, name, department)
SELECT employee_id, name, department
FROM employees
WHERE department = 'IT';

🔹 Insert All Columns (If Structure Matches)

INSERT INTO employees_archive
SELECT * FROM employees
WHERE status = 'inactive';

🔹 Oracle Notes

• Works the same way in Oracle.
• You can also use INSERT /*+ APPEND */ for performance tuning in large loads.

🧠 Quick Recap

✅ Ideal for copying, archiving, or transforming data between tables