CODEWITHSUNDEEP
sqloracle-databasesql-like
Mishthi
Mishthi

Reputation: 1161

Can't we use [specifier] with like operator with Oracle?

When using the LIKE operator in oracle for matching anyone of the characters can't I use [specifier] For eg. Find out the Customer's name starting with either 's' or 'r' SO we can't write query as " select * from emp where customer LIKE '[sr]%'";

Can't we use "[]" braces with LIKE operator in ORACLE?

Upvotes: 1

Views: 984

Answers (1)

Thilo
Thilo

Reputation: 262504

No, LIKE does not do that.

But you can use regular expressions.

select * from emp where REGEXP_LIKE (customer, '^[sr].*');

Upvotes: 5

Related Questions