aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DB2 Administration and Oracle SQL Functions
  • What is the result of the query "Select length(to_char(to...
Multiple choice technology databases

What is the result of the query "Select length(to_char(to_date(11032007,'ddmmyyyy'),'March')) from dual;" ?

  1. 3

  2. 5

  3. 9

  4. Error

Reveal answer Fill a bubble to check yourself
C Correct answer

Keep practicing — related questions

  • What will be Output of the following query? select length(to_char('9999','999999.99')) from dual
  • The output of the query " Select length(to_char(2000,'9999')) from dual; " is 4.
  • What's the output select to_Date('2009-may-25','yyyymmdd') from dual
  • What's the output select to_Date('2009-may-25','yyyymmdd') from dual
  • The output of the query " Select length(substr('SQL Functions',-10,12)) from dual; " is
  • The output of the query "select length('This is Ram''s book') from dual; " is
  • Assuming the date and time is 09/09/2009 09:09:09, what value will the following statement return SELECT TO...
  • Select length(-1) from dual What is the output of the above sql stmt
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy