Home » Developer & Programmer » Forms » use like operator with if condition
use like operator with if condition [message #575075] Sat, 19 January 2013 00:18 Go to next message
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%'.

Re: use like operator with if condition [message #575111 is a reply to message #575075] Sat, 19 January 2013 11:05 Go to previous message
Messages: 21148
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;
Previous Topic: Tuning view
Next Topic: Image not displaying
Goto Forum:

Current Time: Mon Aug 21 05:26:47 CDT 2017

Total time taken to generate the page: 0.16753 seconds