Which script displays '01-MAR-03' when the JOIN_DATE value is '03-MAR-03'?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement sho...
- SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) FROM DUAL;
- You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement sho...
- You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement sho...
- What's the output select to_Date('2009-may-25','yyyymmdd') from dual
- You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement sho...
- Assuming the date and time is 09/09/2009 09:09:09, what value will the following statement return SELECT TO...
- SELECT TO_CHAR( ADD_MONTHS(to_date('07-JUN-1994,'DD-MON-YYYY'),1), 'DD-MON-YYYY') FROM employees WHERE last...