bash – 如何使用sed在文件中的每一行之前插入一行,原始行的内容

输入：

truncate table ALPHA;
truncate table BETA;
delete from TABLE_CHARLIE where ID=1;

预期结果：

SELECT 'truncate table ALPHA;' from dual;
truncate table ALPHA;
SELECT 'truncate table BETA;' from dual;
truncate table BETA;
SELECT 'delete from TABLE_CHARLIE where ID=1;' from dual;
delete from TABLE_CHARLIE where ID=1;

我试图使用&符号(&)特殊字符,但这似乎不起作用.如果我在替换字符串上放了&符之后的任何内容,则输出不正确.

尝试1：

sed -e "s/(.*)/SELECT '&n&/g" input.txt

output:
SELECT 'truncate table ALPHA;
truncate table ALPHA;
SELECT 'truncate table BETA;
truncate table BETA;
SELECT 'delete from TABLE_CHARLIE where ID=1;
delete from TABLE_CHARLIE where ID=1;

使用前面的代码,我按预期得到了SELECT’,但是一旦我尝试添加’from dual;在字符串的右侧,事情变得糟糕.

尝试2：

sed -e "s/(.*)/SELECT '&' from dual;n&/g"  input.txt

output:
' from dual;cate table ALPHA;
truncate table ALPHA;
' from dual;cate table BETA;
truncate table BETA;
SELECT 'delete from TABLE_CHARLIE where ID=1;' from dual;