1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Using LIKE in Oracle

Using LIKE
Look at the EmployeeStatisticsTable, and say you wanted to see all people whose last names started with "S";
try:
SELECT EMPLOYEEIDNO
FROM EMPLOYEEADDRESSTABLE
WHERE LASTNAME LIKE 'S%';
The percent sign (%) is used to represent any possible character (number, letter, or punctuation) or set of
characters that might appear after the "S". To find those people with LastName's ending in "S", use '%S', or if
you wanted the "S" in the middle of the word, try '%S%'. The '%' can be used for any characters in the same
position relative to the given characters. NOT LIKE displays rows not fitting the given description. Other
possibilities of using LIKE, or any of these discussed conditionals, are available, though it depends on what
DBMS you are using; as usual, consult a manual or your system manager or administrator for the available
features on your system, or just to make sure that what you are trying to do is available and allowed. This
disclaimer holds for the features of SQL that will be discussed below. This section is just to give you an idea of
the possibilities of queries that can be written in SQL.

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy