Hi,<\/p>\n
I will explain SQL Like Operator in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n
<\/p>\n
\n
Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\nSQL SELECT Statement and DESC Command in Oracle SQL | Oracle SQL Tutorials -2<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The LIKE operator is very popular operator in Oracle SQL that is used in a WHERE clause to search for a specified pattern in a column.<\/p>\n<p align=\"left\">There are two types of wildcards used with the LIKE operator as follows.<\/p>\n<ul>\n<li>_ ( underscore ) represents matching only a single character.<\/li>\n<li>% ( Percent Sign ) represents matching one or multiple characters in Where clause.<\/li>\n<\/ul>\n<p> <\/p>\n<pre><\/pre>\n<h4><span style=\"color: #ff0000;\">LIKE Syntax<\/span><\/h4>\n<p>The LIKE Syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>* <\/em><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>column <\/em><span class=\"sqlkeywordcolor\">LIKE<\/span>\u00a0<em>pattern<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT <\/span><em>column1, column2, …<\/em><span class=\"sqlkeywordcolor\">FROM <\/span><em>table_name<\/em><br \/>\n<span class=\"sqlkeywordcolor\">WHERE <\/span><em>column <\/em><span class=\"sqlkeywordcolor\">LIKE <\/span><em>pattern<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Like operator and its usage with examples are as follows.<\/div>\n<div><\/div>\n<div>\n<table style=\"width: 99.1091%;\" width=\"673\">\n<tbody>\n<tr>\n<td style=\"width: 48.8095%;\" width=\"208\"><span style=\"color: #ff0000;\"><strong>LIKE Operator<\/strong><\/span><\/td>\n<td style=\"width: 94.494%;\" width=\"465\"><span style=\"color: #ff0000;\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘e%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%e’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that end with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%msd%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “msd” in any position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘_b%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “b” in the second position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u_%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 2 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u__%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 3 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u%a’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and ends with “a”<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<pre>\r\n\r\nFind the employees that first name start with <span style=\"color: #ff0000;\"><strong>a<\/strong><\/span> character.\r\n\r\n<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like 'a%'; \r\n\r\nno rows selected\r\n\r\nSQL> \r\n\r\n\r\nFind the employees that first name start with <strong><span style=\"color: #ff0000;\">A<\/span><\/strong> character.\r\n\r\nSQL> \r\nSQL> select first_name,last_name,salary from hr.employees where first_name like 'A%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nAmit Banda 7200\r\nAlexis Bull 5100\r\nAnthony Cabrio 4000\r\nAlberto Errazuriz 13000\r\nAdam Fripp 9200\r\nAlexander Hunold 10000\r\nAlyssa Hutton 9800\r\nAlexander Khoo 4100\r\nAllan McEwen 10000\r\nAlana Walsh 4100\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<pre>\r\n\r\n\r\nFind the employees that first name end with <span style=\"color: #ff0000;\"><b>a <\/b><\/span>character.<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%a';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLaura Bissot 4300\r\nJulia Dellinger 4400\r\nAlyssa Hutton 9800\r\nNeena Kochhar 23000\r\nSundita Kumar 7100\r\nDiana Lorentz 5200\r\nMattea Marvins 8200\r\nJulia Nayer 4200\r\nLisa Ozer 12500\r\nJoshua Patel 3500\r\nTrenna Rajs 4500\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nNandita Sarchand 5200\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\nShanta Vollman 7500\r\nAlana Walsh 4100\r\n\r\n16 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p>Find the employees that first name have “ar” in any position as follows.<\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%ar%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSundar Ande 7400\r\nSarah Bell 5000\r\nHarrison Bloom 11000\r\nKaren Colmenares 3500\r\nGirard Geoni 3800\r\nCharles Johnson 7200\r\nKaren Partners 14500\r\nSarath Sewall 8000\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name have “e” in the second position<\/p>\n<p> <\/p>\n<pre>SQL> \r\nSQL> select first_name,last_name,salary from hr.employees where last_name like '_e%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLex De Haan 23000\r\nMatthew Weiss 9000\r\nKi Gee 3400\r\nJohn Seo 3700\r\nDavid Bernstein 10500\r\nSarath Sewall 8000\r\nDavid Lee 7800\r\nGirard Geoni 3800\r\nJulia Dellinger 4400\r\nRandall Perkins 3500\r\nSarah Bell 5000\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nKevin Feeney 4000\r\n\r\n12 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name start with “B” and ends with “l”<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B%l';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSarah Bell 5000\r\nAlexis Bull 5100\r\n\r\nSQL> \r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n<p>Find the employees that last name start with “B” and are at least 3 characters in length<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B__%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nHermann Baer 11000\r\nShelli Baida 3900\r\nAmit Banda 7200\r\nElizabeth Bates 8300\r\nSarah Bell 5000\r\nDavid Bernstein 10500\r\nLaura Bissot 4300\r\nHarrison Bloom 11000\r\nAlexis Bull 5100\r\n\r\n9 rows selected.\r\n\r\nSQL><\/pre>\n<p>fwe<\/p>\n<pre>\r\n\r\n<\/pre>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hYe3d0LZPG\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=3U46haFBFU#?secret=hYe3d0LZPG\" data-secret=\"hYe3d0LZPG\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain SQL Like Operator in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11559,11557,11565,11564,11558,9037,11556,11351,11304,11563,3001,11302,2673,11301,3715,3185,11551,11550,11554,11552,3186,11561,11562,11553,11560,11555],"class_list":["post-16190","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-in-operator-in-sql","tag-in-sql","tag-like-operator-sql","tag-like-sql","tag-multiple-like-in-sql","tag-oracle-dba-tutorial","tag-oracle-like","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-like","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-like","tag-sql-like-escape","tag-sql-like-multiple-values","tag-sql-like-multiple-words","tag-sql-like-number","tag-sql-like-operator","tag-sql-like-operator-in-oracle-sql","tag-sql-like-oracle","tag-sql-like-regex","tag-sql-not-like","tag-sql-like-case-insensitive"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16190"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions"}],"predecessor-version":[{"id":16191,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions\/16191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SQL SELECT Statement and DESC Command in Oracle SQL | Oracle SQL Tutorials -2<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The LIKE operator is very popular operator in Oracle SQL that is used in a WHERE clause to search for a specified pattern in a column.<\/p>\n<p align=\"left\">There are two types of wildcards used with the LIKE operator as follows.<\/p>\n<ul>\n<li>_ ( underscore ) represents matching only a single character.<\/li>\n<li>% ( Percent Sign ) represents matching one or multiple characters in Where clause.<\/li>\n<\/ul>\n<p> <\/p>\n<pre><\/pre>\n<h4><span style=\"color: #ff0000;\">LIKE Syntax<\/span><\/h4>\n<p>The LIKE Syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>* <\/em><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>column <\/em><span class=\"sqlkeywordcolor\">LIKE<\/span>\u00a0<em>pattern<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT <\/span><em>column1, column2, …<\/em><span class=\"sqlkeywordcolor\">FROM <\/span><em>table_name<\/em><br \/>\n<span class=\"sqlkeywordcolor\">WHERE <\/span><em>column <\/em><span class=\"sqlkeywordcolor\">LIKE <\/span><em>pattern<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Like operator and its usage with examples are as follows.<\/div>\n<div><\/div>\n<div>\n<table style=\"width: 99.1091%;\" width=\"673\">\n<tbody>\n<tr>\n<td style=\"width: 48.8095%;\" width=\"208\"><span style=\"color: #ff0000;\"><strong>LIKE Operator<\/strong><\/span><\/td>\n<td style=\"width: 94.494%;\" width=\"465\"><span style=\"color: #ff0000;\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘e%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%e’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that end with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%msd%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “msd” in any position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘_b%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “b” in the second position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u_%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 2 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u__%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 3 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u%a’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and ends with “a”<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<pre>\r\n\r\nFind the employees that first name start with <span style=\"color: #ff0000;\"><strong>a<\/strong><\/span> character.\r\n\r\n<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like 'a%'; \r\n\r\nno rows selected\r\n\r\nSQL> \r\n\r\n\r\nFind the employees that first name start with <strong><span style=\"color: #ff0000;\">A<\/span><\/strong> character.\r\n\r\nSQL> \r\nSQL> select first_name,last_name,salary from hr.employees where first_name like 'A%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nAmit Banda 7200\r\nAlexis Bull 5100\r\nAnthony Cabrio 4000\r\nAlberto Errazuriz 13000\r\nAdam Fripp 9200\r\nAlexander Hunold 10000\r\nAlyssa Hutton 9800\r\nAlexander Khoo 4100\r\nAllan McEwen 10000\r\nAlana Walsh 4100\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<pre>\r\n\r\n\r\nFind the employees that first name end with <span style=\"color: #ff0000;\"><b>a <\/b><\/span>character.<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%a';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLaura Bissot 4300\r\nJulia Dellinger 4400\r\nAlyssa Hutton 9800\r\nNeena Kochhar 23000\r\nSundita Kumar 7100\r\nDiana Lorentz 5200\r\nMattea Marvins 8200\r\nJulia Nayer 4200\r\nLisa Ozer 12500\r\nJoshua Patel 3500\r\nTrenna Rajs 4500\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nNandita Sarchand 5200\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\nShanta Vollman 7500\r\nAlana Walsh 4100\r\n\r\n16 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p>Find the employees that first name have “ar” in any position as follows.<\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%ar%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSundar Ande 7400\r\nSarah Bell 5000\r\nHarrison Bloom 11000\r\nKaren Colmenares 3500\r\nGirard Geoni 3800\r\nCharles Johnson 7200\r\nKaren Partners 14500\r\nSarath Sewall 8000\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name have “e” in the second position<\/p>\n<p> <\/p>\n<pre>SQL> \r\nSQL> select first_name,last_name,salary from hr.employees where last_name like '_e%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLex De Haan 23000\r\nMatthew Weiss 9000\r\nKi Gee 3400\r\nJohn Seo 3700\r\nDavid Bernstein 10500\r\nSarath Sewall 8000\r\nDavid Lee 7800\r\nGirard Geoni 3800\r\nJulia Dellinger 4400\r\nRandall Perkins 3500\r\nSarah Bell 5000\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nKevin Feeney 4000\r\n\r\n12 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name start with “B” and ends with “l”<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B%l';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSarah Bell 5000\r\nAlexis Bull 5100\r\n\r\nSQL> \r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n<p>Find the employees that last name start with “B” and are at least 3 characters in length<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B__%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nHermann Baer 11000\r\nShelli Baida 3900\r\nAmit Banda 7200\r\nElizabeth Bates 8300\r\nSarah Bell 5000\r\nDavid Bernstein 10500\r\nLaura Bissot 4300\r\nHarrison Bloom 11000\r\nAlexis Bull 5100\r\n\r\n9 rows selected.\r\n\r\nSQL><\/pre>\n<p>fwe<\/p>\n<pre>\r\n\r\n<\/pre>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hYe3d0LZPG\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=3U46haFBFU#?secret=hYe3d0LZPG\" data-secret=\"hYe3d0LZPG\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain SQL Like Operator in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11559,11557,11565,11564,11558,9037,11556,11351,11304,11563,3001,11302,2673,11301,3715,3185,11551,11550,11554,11552,3186,11561,11562,11553,11560,11555],"class_list":["post-16190","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-in-operator-in-sql","tag-in-sql","tag-like-operator-sql","tag-like-sql","tag-multiple-like-in-sql","tag-oracle-dba-tutorial","tag-oracle-like","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-like","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-like","tag-sql-like-escape","tag-sql-like-multiple-values","tag-sql-like-multiple-words","tag-sql-like-number","tag-sql-like-operator","tag-sql-like-operator-in-oracle-sql","tag-sql-like-oracle","tag-sql-like-regex","tag-sql-not-like","tag-sql-like-case-insensitive"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16190"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions"}],"predecessor-version":[{"id":16191,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions\/16191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The LIKE operator is very popular operator in Oracle SQL that is used in a WHERE clause to search for a specified pattern in a column.<\/p>\n<p align=\"left\">There are two types of wildcards used with the LIKE operator as follows.<\/p>\n<ul>\n<li>_ ( underscore ) represents matching only a single character.<\/li>\n<li>% ( Percent Sign ) represents matching one or multiple characters in Where clause.<\/li>\n<\/ul>\n<p> <\/p>\n<pre><\/pre>\n<h4><span style=\"color: #ff0000;\">LIKE Syntax<\/span><\/h4>\n<p>The LIKE Syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>* <\/em><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>column <\/em><span class=\"sqlkeywordcolor\">LIKE<\/span>\u00a0<em>pattern<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT <\/span><em>column1, column2, …<\/em><span class=\"sqlkeywordcolor\">FROM <\/span><em>table_name<\/em><br \/>\n<span class=\"sqlkeywordcolor\">WHERE <\/span><em>column <\/em><span class=\"sqlkeywordcolor\">LIKE <\/span><em>pattern<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Like operator and its usage with examples are as follows.<\/div>\n<div><\/div>\n<div>\n<table style=\"width: 99.1091%;\" width=\"673\">\n<tbody>\n<tr>\n<td style=\"width: 48.8095%;\" width=\"208\"><span style=\"color: #ff0000;\"><strong>LIKE Operator<\/strong><\/span><\/td>\n<td style=\"width: 94.494%;\" width=\"465\"><span style=\"color: #ff0000;\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘e%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%e’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that end with “e”<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘%msd%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “msd” in any position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘_b%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that have “b” in the second position<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u_%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 2 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u__%’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and are at least 3 characters in length<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 48.8095%;\">WHERE FirstName LIKE ‘u%a’<\/td>\n<td style=\"width: 94.494%;\">Finds any values that start with “u” and ends with “a”<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<pre>\r\n\r\nFind the employees that first name start with <span style=\"color: #ff0000;\"><strong>a<\/strong><\/span> character.\r\n\r\n<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like 'a%'; \r\n\r\nno rows selected\r\n\r\nSQL> \r\n\r\n\r\nFind the employees that first name start with <strong><span style=\"color: #ff0000;\">A<\/span><\/strong> character.\r\n\r\nSQL> \r\nSQL> select first_name,last_name,salary from hr.employees where first_name like 'A%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nAmit Banda 7200\r\nAlexis Bull 5100\r\nAnthony Cabrio 4000\r\nAlberto Errazuriz 13000\r\nAdam Fripp 9200\r\nAlexander Hunold 10000\r\nAlyssa Hutton 9800\r\nAlexander Khoo 4100\r\nAllan McEwen 10000\r\nAlana Walsh 4100\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<pre>\r\n\r\n\r\nFind the employees that first name end with <span style=\"color: #ff0000;\"><b>a <\/b><\/span>character.<\/pre>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%a';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLaura Bissot 4300\r\nJulia Dellinger 4400\r\nAlyssa Hutton 9800\r\nNeena Kochhar 23000\r\nSundita Kumar 7100\r\nDiana Lorentz 5200\r\nMattea Marvins 8200\r\nJulia Nayer 4200\r\nLisa Ozer 12500\r\nJoshua Patel 3500\r\nTrenna Rajs 4500\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nNandita Sarchand 5200\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\nShanta Vollman 7500\r\nAlana Walsh 4100\r\n\r\n16 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p>Find the employees that first name have “ar” in any position as follows.<\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where first_name like '%ar%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSundar Ande 7400\r\nSarah Bell 5000\r\nHarrison Bloom 11000\r\nKaren Colmenares 3500\r\nGirard Geoni 3800\r\nCharles Johnson 7200\r\nKaren Partners 14500\r\nSarath Sewall 8000\r\nMartha Sullivan 3500\r\nClara Vishney 11500\r\n\r\n10 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name have “e” in the second position<\/p>\n<p> <\/p>\n<pre>SQL> \r\nSQL> select first_name,last_name,salary from hr.employees where last_name like '_e%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nLex De Haan 23000\r\nMatthew Weiss 9000\r\nKi Gee 3400\r\nJohn Seo 3700\r\nDavid Bernstein 10500\r\nSarath Sewall 8000\r\nDavid Lee 7800\r\nGirard Geoni 3800\r\nJulia Dellinger 4400\r\nRandall Perkins 3500\r\nSarah Bell 5000\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nKevin Feeney 4000\r\n\r\n12 rows selected.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>Find the employees that last name start with “B” and ends with “l”<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B%l';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nSarah Bell 5000\r\nAlexis Bull 5100\r\n\r\nSQL> \r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n<p>Find the employees that last name start with “B” and are at least 3 characters in length<\/p>\n<p> <\/p>\n<pre>SQL> select first_name,last_name,salary from hr.employees where last_name like 'B__%';\r\n\r\nFIRST_NAME LAST_NAME SALARY\r\n-------------------- ------------------------- ----------\r\nHermann Baer 11000\r\nShelli Baida 3900\r\nAmit Banda 7200\r\nElizabeth Bates 8300\r\nSarah Bell 5000\r\nDavid Bernstein 10500\r\nLaura Bissot 4300\r\nHarrison Bloom 11000\r\nAlexis Bull 5100\r\n\r\n9 rows selected.\r\n\r\nSQL><\/pre>\n<p>fwe<\/p>\n<pre>\r\n\r\n<\/pre>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hYe3d0LZPG\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=3U46haFBFU#?secret=hYe3d0LZPG\" data-secret=\"hYe3d0LZPG\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain SQL Like Operator in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11559,11557,11565,11564,11558,9037,11556,11351,11304,11563,3001,11302,2673,11301,3715,3185,11551,11550,11554,11552,3186,11561,11562,11553,11560,11555],"class_list":["post-16190","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-in-operator-in-sql","tag-in-sql","tag-like-operator-sql","tag-like-sql","tag-multiple-like-in-sql","tag-oracle-dba-tutorial","tag-oracle-like","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-like","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-like","tag-sql-like-escape","tag-sql-like-multiple-values","tag-sql-like-multiple-words","tag-sql-like-number","tag-sql-like-operator","tag-sql-like-operator-in-oracle-sql","tag-sql-like-oracle","tag-sql-like-regex","tag-sql-not-like","tag-sql-like-case-insensitive"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16190"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions"}],"predecessor-version":[{"id":16191,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16190\/revisions\/16191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\")
<\/p>\n<\/p>\n