What is the result of the query "Select length(to_char(to_date(11032007,'ddmmyyyy'),'March')) from dual;" ?
Reveal answer
Fill a bubble to check yourself
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