How to Create a Like Statement in Plsql

Submit Your Tip

How to Create a Like Statement in Plsql – This is a place for the community to provide tips and advice on How to Create a Like Statement in Plsql. This topic was created by Jaime Aguilar and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Tip 1 - Use a variable with "LIKE %" (e.g. "variable%") in PL/SQL?

Published: 9 years, 1 month(s) ago | Submitted by Robert Iannarelli | permalink

The question is similar to using LIKE in SQL *PLUS, where a select statement contains a LIKE clause as follows: select * from sometable where somecolumn LIKE 'something%'; How could one use the ...

For further reading: http://stackoverflow.com/questions/10150723/use-a-variable-with-like-e-g-variable-in-pl-sql ^[1]

Tip 2 - PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries

Published: 9 years, 1 month(s) ago | Submitted by Henrik Cederlu 00f 6f | permalink

We're using Oracle 11g database. As you may or may not know, if you use wildcard query with "%" in front of the string, the column index is not being used and a full table scan is happening. It l...

For further reading: http://stackoverflow.com/questions/6229445/pl-sql-performance-tuning-for-like-wildcard-queries ^[2]

Tip 3 - Is there a combination of "LIKE" and "IN" in SQL?

Published: 9 years, 1 month(s) ago | Submitted by ngoodnight | permalink

In SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question. Further...

For further reading: http://stackoverflow.com/questions/3014940/is-there-a-combination-of-like-and-in-in-sql ^[3]