Multiple choice technology databases

What is the result of this: initcap("gadde");

  1. GADDE

  2. Gadde

  3. gADDE

  4. THERE IS NO FUNCTION LIKE initcap();
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Oracle SQL function INITCAP() converts the first letter of each word to uppercase and all remaining letters to lowercase. When applied to 'gadde', it returns 'Gadde' with only the first letter capitalized. This function is commonly used for formatting names and titles in database queries.

Keep practicing — related questions