How to Create a Like Statement in Plsql

submit to reddit

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.

Votes

Tips

1
- Vote
Tip 1
Use a variable with "LIKE %" (e.g. "variable%") in PL/SQL? More
Published: 9 years, 4 month(s) ago by Robert Iannarelli | permalink
Vote
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]

1
- Vote
Tip 2
PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries More
Published: 9 years, 4 month(s) ago by Henrik Cederlu 00f 6f | permalink
Vote
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]

1
- Vote
Tip 3
Is there a combination of "LIKE" and "IN" in SQL? More
Published: 9 years, 4 month(s) ago by ngoodnight | permalink
Vote
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]

About Author

More by Jaime Aguilar

No more topics...

About This Topic

Category: Fun | 9 years, 4 month(s) ago

8.7k+ Reads

3 Tips

3 Votes

0 Likes

0 Saved

Contributors

Henrik Cederlu 00f 6f, ngoodnight, Robert Iannarelli

References & Citations

1. http://stackoverflow.com/questions/10150723/use-a-variable-with-like-e-g-variable-in-pl-sql

2. http://stackoverflow.com/questions/6229445/pl-sql-performance-tuning-for-like-wildcard-queries

3. http://stackoverflow.com/questions/3014940/is-there-a-combination-of-like-and-in-in-sql