Like clause [message #434448] |
Wed, 09 December 2009 05:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |
![GETRITESH00%40YAHOO.COM](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
how to introduce & in wild search as shown below
SELECT *
FROM emp
WHERE ENAME LIKE '%JPMORGAN & CO&';
Here oracle takes "&" in '%JPMORGAN & CO&' as Substitution variable.I want oracle to take whole as a search string
Regards,
Ritesh
|
|
|
|
|
Re: Like clause [message #434465 is a reply to message #434448] |
Wed, 09 December 2009 06:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |
![GETRITESH00%40YAHOO.COM](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
thanks for reply
i want to use this in stored procedure and that stored procedure is going to get called in microsoft sharepoint.
There i cant use
SET DEFINE OFF
Please suggest me some alternate solution
Regards,
Ritesh Tidke
{Mod Edit: Altered case of final statement so that OP is not SHOUTING!]
[Updated on: Wed, 09 December 2009 06:07] by Moderator Report message to a moderator
|
|
|
Re: Like clause [message #434472 is a reply to message #434465] |
Wed, 09 December 2009 06:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
The substition takes place on the client side (SQL*Plus for example). Which sort of client/driver do you use to connect to Oracle from sharepoint?
|
|
|
|
|
|