Would like to know, if this is the correct method of using the LIKE in a Condition?

Would like to know, if this is the correct method of using the LIKE in a Condition?
Best answer by Charana Udugama
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.