|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: IN
Definition: SELECT * In the query above, Oracle would select only those records where the salary is equal to either 1500, or 3000, or 2500. It would not match a salary of '1800'. SELECT * In the query above, Oracle would select only those records where the CITY is equal to 'Seattle', 'Memphis', or 'Los Angeles'. Note that the list items are enclosed with single quotation marks since they are non-numeric strings. Similarly, the query below finds any employee whose last name is included in the list of names. The query selects those employees whose last name is SMITH, JONES, WILSON, or ROGERS. SELECT LAST_NAME, SALARY, EMPNO Related Links:
Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |