Insert a file at specific line

UNIX Solaris
1

Hi,

Anyone can help me in Solaris command on how to insert a file at specific line.

I want file1.sql content to be inserted on file2.sh after "recover database using backup controlfile until cancel".

# file1.sql

/archivelogs/927_822338133.arc
/archivelogs/671_822338107.arc
/archivelogs/911_822340363.arc

# file2.sh

#!/usr/bin/sh
sqlplus -s / as sysdba <<!
recover database using backup controlfile until cancel
cancel
exit
!

Thank in advance.

Regards,
FSPalero

2

Here is one way:

ed file2.sql <<%
/recover database using backup controlfile until cancel
.r file1.sql
w 
%
3 
sed '/recover/ r file1' file2
#!/usr/bin/sh
sqlplus -s / as sysdba <<!
recover database using backup controlfile until cancel
/archivelogs/927_822338133.arc
/archivelogs/671_822338107.arc
/archivelogs/911_822340363.arc
cancel
exit
!
4

Hi,

Many thanks for the help.

Regards,
FSPalero