Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

Character Functions: SUBSTR, INSTR, LENGTH and Case

Lesson 11 of 23 Lab 🔒 Locked

Lessons in this course

  1. SELECT, Arithmetic and Column AliasesLabFree
  2. DUAL, Bind Variables and Operator PrecedenceLab Locked
  3. Column Aliases, Quotes and DISTINCTLab Locked
  4. WHERE: Comparisons, BETWEEN, IN and LIKELab Locked
  5. ORDER BY and Where the NULLs GoLab Locked
  6. NULL: Unknown Values in Filters and ArithmeticLab Locked
  7. NVL: Replacing NULL Before It Breaks Your TotalsLab Locked
  8. NVL2: Different Results for NULL and Not NULLLab Locked
  9. COALESCE and NULLIFLab Locked
  10. Concatenation with || and CONCATLab Locked
  11. Character Functions: SUBSTR, INSTR, LENGTH and CaseLab Locked
  12. LPAD, RPAD, TRIM and REPLACELab Locked
  13. Number Functions: ROUND, TRUNC, CEIL, FLOOR, MODLab Locked
  14. SYSDATE and Date ArithmeticLab Locked
  15. MONTHS_BETWEEN, ADD_MONTHS, LAST_DAY and NEXT_DAYLab Locked
  16. TRUNC, ROUND and EXTRACT on DatesLab Locked
  17. TO_CHAR with Dates: Format ModelsLab Locked
  18. TO_CHAR with Numbers: Formats, FM and ####Lab Locked
  19. TO_DATE, Date Literals and Implicit ConversionLab Locked
  20. CASE and DECODE: If-Then Logic in a QueryLab Locked
  21. Top-N Queries: FETCH FIRST, OFFSET and ROWNUMLab Locked
  22. Sequences: NEXTVAL, CURRVAL and GapsLab Locked
  23. Final Project: An HR Report QueryLab Locked