We want to remove the leading and trailing double quotes from the column as the double quotes are hidden in the column in sql developer..
Example:
This is the string where we want to remove the double quotes but the string split into two lines when copy paste from sql developer.
"CHUTE PLATE SKIRT 3/8X 16X8'
22DEG BEND W/ 3/4 COLD ROLL"
and the query i tried is,
SELECT REPLACE(item_description, '"', '') from po_lines_all where item_description like'%CHUTE%PLATE%'; -- but it is not removing the hidden double quotes.
