aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • SQL Views, Joins, and Database Operations Quiz
  • Convert a date to a character expression
Multiple choice technology databases

Convert a date to a character expression

  1. SELECT SUBSTR ('HelloWorld',1) FROM dual;

  2. SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual;

  3. SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual;

  4. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Reveal answer Fill a bubble to check yourself
D Correct answer

Keep practicing — related questions

  • Which SELECT statement will the result 'ello world' from the string 'Hello World'?
  • Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?
  • Which SELECT statement will result "ello world" from the string "Hello World"?
  • Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
  • Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?
  • Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?
  • Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?
  • Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy