Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

replace the value in a string by the input from user

683484Jun 9 2009 — edited Jun 10 2009

I have the following query

Update table1 set col1 = replace('ServerName\folder1\test', 'ServerName', @Servername)

I have to run this in sqlplus.
I want to ask the user the value for the @ServerName and replace it to the Servername in the string above.

Does anyone know how to do it?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2009

Added on Jun 9 2009

#general-database-discussions

5 comments

696 views