OraFAQ Forum: SQL & PL/SQL » Search through Wild Card character

Home » SQL & PL/SQL » SQL & PL/SQL » Search through Wild Card character

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Search through Wild Card character [message #323007]

Tue, 27 May 2008 01:05

kecd_deepak
Messages: 52
Registered: December 2007

Member

Hello,
How i search for 'xy_cv' type data through a sql querry.
I write the search criteria inside DECODE statement.

select * from test1 where name like DECODE('&x','_','%\_%' escape '\','%scott%')

I get following error message.

Error Meassage:
ORA-00907: missing right parenthesis

Thanks.

[Mod-edit: Frank corrected code-tag. (wrong slash in closing tag)]

[Updated on: Tue, 27 May 2008 01:09] by Moderator

Report message to a moderator

Re: Search through Wild Card character [message #323009 is a reply to message #323007]

Tue, 27 May 2008 01:12

Frank
Messages: 7901
Registered: March 2000

Senior Member

Move the escape to outside the decode like this:

select * from test1 where name like DECODE('&x', '_', '%\_%', '%scott%') escape '\'

[Updated on: Tue, 27 May 2008 01:12]

Report message to a moderator

Re: Search through Wild Card character [message #323010 is a reply to message #323007]

Tue, 27 May 2008 01:26

kecd_deepak
Messages: 52
Registered: December 2007

Member

Thanks Frank
Actually such a problem ,i faced first time.

Again Thanks

Report message to a moderator

Previous Topic:	Extract in csv format in Oracle SQL
Next Topic:	Search with special character ('%')

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 18 09:32:17 CST 2025