Hi
try this

select *
from wf_item_attribute_values
where text_value like 'Element QUANTITY not complete, expected elements '
|| '''[UOM]'''






"BenBart " <oracledba-ezmlmshield-x26836883.[Email address protected]
01/05/2006 10:11 AM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: SQL - HOW TO - Am sure Anthony knows this one


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)





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page