Selecting from table with a string that contains a resevered word.
I am trying to select a table column, however this particular value contains a reseved word (local). I have tried using \ within the string to mask out the resevered word however this doesn't work. This was within sqlplus. I have also tried this in PL/SQL :-
SET SERVEROUTPUT ON size 1000000
DECLARE
V_PARAM VARCHAR2(2000);
V_PHASE VARCHAR2(2);
BEGIN
V_PHASE := '92';
V_PARAM := 'SERVICE_WSDL_URL=http://hypappcp008.live.<mydomain>.local/PSIGW/PeopleSoftServiceListeningConnector/RC_EBS_LOCATION_INC_SERV
ICE.1.wsdl SERVICE_NAME=RC_EBS_LOCATION_INC_SERVICE SERVICE_PORT=RC_EBS_LOCATION_INC_SERVICE_Port SERVICE_PORTTYPE=RC_EBS_LOCATION_