Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
For better view click here
x
Hire a Tutor
DISCOVER

ORACLE SQL

Loading...

Published in: Oracle Training
1,230 Views

ORACLE SQL

Debarun S / Kolkata

10 years of teaching experience

Qualification: B.Tech

Teaches: Computer, Mathematics, Science, Chemistry, Computer Science, Physics, School Level Computer, Defence Exams, IBPS, Insurance Exams, SSC Exams

Contact this Tutor
  1. SQL LIKE Operator The SQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards used in conjunction with the LIKE operator: % - The percent sign represents zero, one, or multiple characters - The underscore represents a single character Note: MS Access uses a question mark (?) instead of the underscore (_). The percent sign and the underscore can also be used in combinations! LIKE Syntax SELECT column], column2 FROM table name WHERE columnN LIKE pattern; Tip: You can also combine any number of conditions using AND or OR operators. Here are some examples showing different LIKE operators with '%' and '_' wildcards: LIKE Operator WHERE CustomerName LIKE WHERE CustomerName LIKE 'Zoa' WHERE CustomerName LIKE '%or%' WHERE CustomerName LIKE r%' WHERE CustomerName LIKE WHERE ContactName LIKE 'a%o' Demo Database Description Finds any values that starts with "a" Finds any values that ends with "a" Finds any values that have "or" in any position Finds any values that have "r" in the second position Finds any values that starts with "a" and are at least 3 characters in length Finds any values that starts with "a" and ends with "o"
  2. Below is a selection from the "Customers" table in the Northwind sample database: CustomerID CustomerName ContactName Address City PostalCode Country 1 2 3 4 5 Alfreds Futterkiste Maria Anders Ana Trujillo Emparedados y helados Antonio Moreno Taquerfa Around the Horn Berglunds snabbköp Ana Trujillo Antonio Moreno Obere Str. 57 Avda. de la Constituci6n 2222 Berlin 12209 México 05021 D.F. México Mataderos 2312 05023 D.F. 120 Hanover London WAI IDP Thomas Hardy sq. Christina Berguvsvägen 8 Luleå S-958 22 Berglund Germany Mexico Mexico UK Sweden SQL LIKE Examples The following SQL statement selects all customers with a CustomerName starting with "a": Example SELECT * FROM Customers WHERE CustomerName LIKE The following SQL statement selects all customers with a CustomerName ending with "a": Example SELECT * FROM Customers WHERE CustomerName LIKE '%a'; The following SQL statement selects all customers with a CustomerName that have "or" in any position: Example SELECT * FROM Customers WHERE CustomerName LIKE '%or%', The following SQL statement selects all customers with a CustomerName that have "r" in the second position:
  3. Example SELECT * FROM Customers WHERE CustomerName LIKE r%'; The following SQL statement selects all customers with a CustomerName that starts with "a" and are at least 3 characters in length: Example SELECT * FROM Customers WHERE CustomerName LIKE The following SQL statement selects all customers with a ContactName that starts with "a" and ends with "o": Example SELECT * FROM Customers WHERE ContactName LIKE 'a%o'; The following SQL statement selects all customers with a CustomerName that does NOT start with "a": Example SELECT * FROM Customers WHERE CustomerName NOT LIKE

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related Study Notes

Upload Study Notes

If you have your own Study Notes which you think can benefit others, please upload on LearnPick. For each approved Study Note you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > Study Notes > ORACLE SQL