SQL & PL/SQL

I have a column in a table where the data can contain ascii code for special characters such as an apostrophe.

The data looks like this:

CREEK'S LANE

ie for a street named CREEK'S LANE.

I want to replace the ascii representation with the apostrophe and have the returned data show up as: CREEK's LANE

When I try the query below I get prompted for substitution variable value.
I don't seem to be able to find the right syntax to make this query work.

SELECT REPLACE (street_name, ''', '''')
FROM
streets WHERE street_id = 1

Does anybody know how to do this?
Any help would be much appreciated.

Thanks.
George