Would like to know, if this is the correct method of using the LIKE in a Condition?
Best answer by Charana Udugama
View original
This topic has been closed for comments
Userlevel 7
+11
Hi
LIKE condition is used match patterns. This is almost same as what you use in Search in IFSAPPs.
For an example we need names starting with the letter ‘R’. We can put the value as ‘R%’. If we need something that ends with the letters ‘er’. We can put the value as ‘%er’.
Here is a document on the usage of LIKE Oracle / PLSQL: LIKE Condition (techonthenet.com)
Hope this helps.
Regards,
Charana
yes thank you, Realized that after I saw your reply.
I overthought this one.
I need an IN (), but it isn’t available.
I was looking for a way in the condition to say 900 or 500.
I can just try this.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.