Multiple choice technology databases

Which of these is a String Aggregation function used to get values from different rows into a single column?

  1. SUBSTR

  2. CON_STR

  3. CON_CAT

  4. WM_CONCAT
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

WM_CONCAT is an Oracle-specific string aggregation function that concatenates values from multiple rows into a single column. SUBSTR extracts substrings, while CON_STR and CON_CAT are not valid SQL functions.

Keep practicing — related questions