There are times where you need to generate “INSERT” SQL statements from existing data. For example, you may have a production release ready “Delete” SQL statement as shown below to remove some existing records.
|
1 2 |
Delete from employee_table WHERE first_name like ('P%') |
For this script, you need to have a rollback script to insert the values back in.
…