The Oracle SQL Where clause helps to filter data out of the resultset to produce a more concise resultset. In this oracle tutorial, we will see how we can recognize string patterns and filter them in the where clause with examples. 👀
Oracle provides two symbols to make string patterns. Those are % (percentile) and _ (underscore).
When it comes to the strings, the following operations primarily useful.
- Equals to a string
- Contains a string
- Starts with a string
- Ends with a string
- Equals to check by ignoring case
- Starts with having an exact length
- Escape % or _
This page contains (Skip to topic)..
Equals to an exact string
We can filter out exact String with the help of equal to symbol.