OraFAQ Forum: Forms » use like operator with if condition

Home » Developer & Programmer » Forms » use like operator with if condition

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

use like operator with if condition [message #575075]

Sat, 19 January 2013 00:18

laxminath
Messages: 14
Registered: March 2012
Location: calcutta

Junior Member

dear sir

i want to know that how can i use like operator with if condition. i m using oracle10g form builder and it's for search purpose .please help me use sir.

for example ...
if search string=string2 then

message('Record found');

end if ;

i want to use like '%search string%'.

thanx

Report message to a moderator

Re: use like operator with if condition [message #575111 is a reply to message #575075]

Sat, 19 January 2013 11:05

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Suppose that your string is 'OraFAQ Oracle forum' and you want to know whether it is like 'Oracle'; then you'd

if instr('OraFAQ Oracle forum', 'Oracle') > 0 then
   ...
end if;

Report message to a moderator

Previous Topic:	Data Retrieval
Next Topic:	call a block from another form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:13:21 CDT 2024