Select Statement  «Prev 

PL/SQL Operators and Conditions

PL/SQL Operators and conditions 
SELECT * FROM PRODUCT 
WHERE PRODUCT_ID <> 25

SELECT TAX_AMOUNT + TOTAL_ITEM_AMOUNT
FROM CUSTOMER_SALE
WHERE CUST_ID
NOT IN (SELECT CUST_ID
	FROM CUSTOMER
	WHERE LASTNAME LIKE 'S%')

SELECT CREATED_BY_USER 
FROM PET_CARE_LOG
WHERE LAST_UPDATE_DATETIME > SYSDATE -3

  1. This condition means "is not equal."
  2. This is the addition operator for adding two values together.
  3. This condition means the CUST_ID is not found in the list generated by the sub-query.
  4. This condition compares a column to characters. The percent sign is a wildcard.
  5. This condition compares the LAST_UPDATE_DATETIME column value with an expression that subtracts three days from the SYSDATE pseudocolumn. SYSDATE contains the current date and time.