Hi all,

How do I do a SELECT for text that have special characters in them, or more specifically, like this one, that has a single quote on it?

Using T-O-A-D and running ...

select item_type, name
from wf_item_attribute_values
where text_value = 'Element QUANTITY not complete, expected elements '[UOM]'.'

It gives command not ended properly.

I managed to run it as follows though ...

select item_type, name
from wf_item_attribute_values
where text_value = 'Element QUANTITY not complete, expected elements ''[UOM]''.'

Now, I just want to know whether there is any definitive rule on using two single quotes, one only etc. or is there any way that I can specify a ESCAPE character, I thought I've read somewhere that you can but I cannot find where I read it now ... Also, using the ESCAPE character will only work on SQLPlus but not on T-O-A-D?

The table is as follows:

SQL> desc apps.wf_item_attribute_values;
Name Null? Type
----------------------------------------- --------
----------------------------
ITEM_TYPE NOT NULL VARCHAR2(8)
ITEM_KEY NOT NULL VARCHAR2(240)
NAME NOT NULL VARCHAR2(30)
TEXT_VALUE VARCHAR2(4000)
NUMBER_VALUE NUMBER
DATE_VALUE DATE
EVENT_VALUE APPS.WF_EVENT_T
SECURITY_GROUP_ID VARCHAR2(32)




Oracle LazyDBA home page