Oracle Functions, Date and Aggregates

1234567891011121314151617181920212223242526
Across
  1. 2. Returns the number of rows in the result set
  2. 6. Shorthand for extracting information from DATE types
  3. 7. Minimum of all values in the specified column
  4. 10. The function used to right justify values in the console output
  5. 12. The preferred method for handling NULL values in a query
  6. 14. The current server time
  7. 15. This function returns the number of letters in the first parameter
  8. 17. This data type can store partial second values
  9. 20. Format mask to get the seconds from a DATE
  10. 21. The special dummy table in Oracle for table-less calculations and info
  11. 23. Names all non aggregate columns in the query
  12. 24. Second parameter in the TO_CHAR function
  13. 26. This method makes all text lower case
Down
  1. 1. Adds the values of the specified column
  2. 3. Maximum of all values in the specified column
  3. 4. This method doesn't round, but the number does go up
  4. 5. Command used to get the HOUR from a TIMESTAMP
  5. 8. This method returns the index of the second parameter in the first parameter
  6. 9. First parameter in the TO_CHAR function
  7. 11. Format mask to spell out the day of the week
  8. 13. Never a parameter for the COUNT function
  9. 16. Used to restrict the number of results of the result set based on an aggregate function
  10. 18. Function for locating the index of text in another text value
  11. 19. The function equivalent to the % operator in Java, Swift, C, etc.
  12. 22. Average of all values in the specified column
  13. 25. Function type on a column instead of a individual field