Go back to 1Z0-031 - Oracle9i Database: Fundamentals I

Question :-

Question 328 Which command can you use to display the date and time in the form 17:45:01JUL2000 using the default US7ASCII character set?
ALTER SYSTEM SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
ALTER SESSION SET DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
ALTER SESSION SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
ALTER SYSTEM SET NLS_DATE_FORMAT='HH:MI:SS MON-DD-YYYY';

Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ? Click here.