{"id":7906,"date":"2019-04-04T13:04:28","date_gmt":"2019-04-04T13:04:28","guid":{"rendered":"https:\/\/ittutorial.org\/?p=7906"},"modified":"2019-07-18T14:42:33","modified_gmt":"2019-07-18T14:42:33","slug":"oracle-sql-tutorials-chapter-2-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-tutorials-chapter-2-2\/","title":{"rendered":"Oracle SQL Tutorials \u2013 Chapter 2 (Part 2 of 3)"},"content":{"rendered":"<p><strong>IS NULL OPERATOR<\/strong><\/p>\n<ul>\n<li>Let\u2019s list the employees that have manager.<\/li>\n<\/ul>\n<pre>SELECT first_name,last_name, manager_id\r\nFROM hr.employees\r\nWHERE manager_id IS not NULL;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"240\" height=\"129\" class=\"wp-image-7913\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-257.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>LOGICAL OPERATORS<\/strong><\/p>\n<ul>\n<li><strong>AND : <\/strong>It returns TRUE if all operands are TRUE.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"203\" height=\"85\" class=\"wp-image-7914\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-258.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>OR : <\/strong>It returns TRUE if any operand is TRUE.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"202\" height=\"86\" class=\"wp-image-7915\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-259.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>NOT : <\/strong>It returns the reverse of the result.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>AND OPERATOR<\/strong><\/p>\n<ul>\n<li>Let\u2019s list the employees that have salary 7000 or more and have \u2018A\u2019 character in his\/her name.<\/li>\n<\/ul>\n<pre>SELECT employee_id, first_name,last_name, job_id, salary \r\nFROM hr.employees \r\nWHERE salary &gt;= 7000 and first_name LIKE '%A%' <em>;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"127\" class=\"wp-image-7916\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-260.png\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-260.png 351w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-260-300x109.png 300w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>OR OPERATOR<\/strong><\/p>\n<ul>\n<li>Let\u2019s list the employees that has 7000 or more salary; or have \u2018A\u2019 character in his\/her name.<\/li>\n<\/ul>\n<pre>SELECT employee_id, first_name,last_name, job_id, salary \r\nFROM hr.employees \r\nWHERE salary &gt;= 7000 \r\nOR first_name LIKE '%A%' <em>;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"376\" height=\"126\" class=\"wp-image-7917\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-261.png\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-261.png 376w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-261-300x101.png 300w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>NOT OPERATOR<\/strong><\/p>\n<ul>\n<li>Let\u2019s list the employees that are don\u2019t work at the IT_PROG , ST_CLERK or SA_REP.<\/li>\n<\/ul>\n<pre>SELECT first_name,last_name, job_id \r\nFROM hr.employees \r\nWHERE job_id NOT IN ('IT_PROG', 'ST_CLERK', 'SA_REP') ;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"129\" class=\"wp-image-7918\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-262.png\" \/><\/p>\n<ul>\n<li>Let\u2019s list the employees that don\u2019t have \u2018e\u2019 character in his\/her name.<\/li>\n<\/ul>\n<pre>SELECT first_name,last_name, job_id \r\nFROM hr.employees \r\nWHERE first_name NOT LIKE '%e%' ;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"149\" class=\"wp-image-7919\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/word-image-263.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You can continue to read from this link ;<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"aJj8fyI2GI\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-chapter-2-3\/\">Oracle SQL Tutorials \u2013 Chapter 2 (Part 3 of 3)<\/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=\"&#8220;Oracle SQL Tutorials \u2013 Chapter 2 (Part 3 of 3)&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-chapter-2-3\/embed\/#?secret=C9wclV9Ciq#?secret=aJj8fyI2GI\" data-secret=\"aJj8fyI2GI\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IS NULL OPERATOR Let\u2019s list the employees that have manager. SELECT first_name,last_name, manager_id FROM hr.employees WHERE manager_id IS not NULL; &nbsp; LOGICAL OPERATORS AND : It returns TRUE if all operands are TRUE. &nbsp; OR : It returns TRUE if any operand is TRUE. &nbsp; NOT : It returns the reverse of the result. &nbsp; &hellip;<\/p>\n","protected":false},"author":29,"featured_media":0,"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":[1994,3019],"tags":[3009,3048,3010,1340,3001,3013,3014,1572,3192,3195,3003,3017,3191,3197,3196,3052,3189,3190,3016,3193,3194,3000,3012,3002,3008],"class_list":["post-7906","post","type-post","status-publish","format-standard","","category-oracle","category-oracle-sql","tag-how-to-write-sql","tag-learn-oracle","tag-learn-sql","tag-oracle-sql","tag-oracle-sql-tutorial","tag-oracle-sql-tutorials","tag-rules-of-sql","tag-sql","tag-sql-and","tag-sql-and-syntax","tag-sql-commands","tag-sql-komutlari","tag-sql-logical-operator","tag-sql-not","tag-sql-not-syntax","tag-sql-null","tag-sql-null-operator","tag-sql-null-syntax","tag-sql-ogren","tag-sql-or","tag-sql-or-syntax","tag-sql-tutorial","tag-sql-tutorials","tag-what-is-sql","tag-writing-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7906","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=7906"}],"version-history":[{"count":4,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7906\/revisions"}],"predecessor-version":[{"id":7952,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7906\/revisions\/7952"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=7906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=7906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=7906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}