In ORACLE what are the wildcard characters present I want to know ? I have been seeing this tutorial from w3schools and they have listed Wildcard Characters in MS Access and Wildcard Characters in SQL Server.
What about ORACLE?
I have checked ORACLE DOCUMENTATION but there are no wildcard characters present.
If there are wildcard characters present then :
1: What are the equivalent wildcard characters of (^ , #, !) present in ORACLE?
2: How can I use them in ORACLE syntax?
SELECT *
FROM Customers
WHERE City LIKE '[!bsp]%';
What should be the oracle equivalent text of the above code using wildcard ?
You seem to be asking about "wildcard characters" in comparing text strings (as opposed to, for example, the asterisk used in select * from ...). If so: Oracle has the LIKE operator, where the only wildcard characters are percent and underscore, and REGEXP_LIKE (and other regular expression functions) where the wildcard characters are the same as in the POSIX extended regular expression standard.