🎴 Flashcard Mode
SQL and Oracle Database Concepts
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which one of them is not an String Function?
AnswerClick to flip back
A
GROUPING
💡 Explanation:
GROUPING is not a string function - it's used with ROLLUP and CUBE operations to distinguish between NULL values representing group totals and actual NULL data. SOUNDEX evaluates sound similarity, DIFFERENCE compares soundex patterns, and SUBSTRING extracts character strings - all legitimate string functions. GROUPING is an aggregate/analytic function.