 |
Home
Oracle
SQL
PL/SQL
MySQL
MongoDB
PostgreSQL
SQL Server
SQLite
Cassandra
DBMS
Python
Java
Aptitude
Interview Q
ORACLE LIKE CONDITIONIn oracle, like condition is used with select, insert, update, and delete in where clause using wildcard. It allows pattern matching. SyntaxParametersexpression: name of column. pattern: patter to be matched in expression. Pattern can be in one of the following:-
Table 1:
Table 2:
Example 1Query: select * from table1 where name like 's%' 
Example 2Query: select * from table1 where name like '22___' 
Example 3Query: select * from table1 where name NOT like 's%' 
Next TopicMINUS
|
For Videos Join Our Youtube Channel: Join Now
Feedback
- Send your Feedback to [email protected]
Help Others, Please Share
Like/Subscribe us for latest updates or newsletter 
