need help on find and replace entire line?

[Lakshmipathi]

I want to convert this

SQL_STRING=`$ORACLE_HOME/bin/sqlplus -s ${user_name}/${password}@${sid}

into this

SQL_STRING=`/usr/bin/sqlplus ${user_name}/${password}@"(description=(address=(host=1.14.20.31)(protocol=tcp)(port=1521))(connect_data=(sid=${sid})))"

I need to replace this line in all files of a directory.
I used sed for replacing words but not for lines.

Any help?

[burschik]

sed replaces a pattern with a string. It doesn't matter whether the pattern matches just one word or an entire line.

[anklinux]

perl -p -i -e 's\Orignal\Replace\g' `find *`

[Lakshmipathi]

yes..but in my case i'm having special characters ..i tried escape characters but it didn't work for me

[burschik]

Use the backslash ("\") to escape these characters. Moreover, both sed and perl allow you to use to delimit regular expressions with characters other than slash ("/").

[Lakshmipathi]

yes ..it woked....this time i did sed replacement step by step ...

sed -e 's/$ORACLE_HOME/ \/usr/g' -e 's/-s/ /g' -e 's/@${sid}/@\"(description=(address=(host=10.14.20.31)(protocol=tcp)(port=1521)(connect_data=(sid=${sid})))/g' f1.txt

Thanks guyz ....

[spymate]

Try this you may find it usefull

%s/oldline/newline/g