Technical Development - Tiveloper.

TO_CHAR(date, 'format_model') The format model:Must be enclosed by single quotation marksIs case-sensitiveCan include any valid date format elementHas an fm element to remove padded blanks or suppress leading zerosIs separated from the date value by a comma

TO_CHAR(date, 'format_model') The format model:Must be enclosed by single quotation marksIs case-sensitiveCan include any valid date format elementHas an fm element to remove padded blanks or suppress leading zerosIs separated from the date value by a comma

MONTHS_BETWEEN : NUmber of months between two dates MONTHS_BETWEEN(date1,date2) The result canbe positive or negative ADD_MONTHS : Add calendar months to date ADD_MONTHS(date, n) "n" must be an integer and can be negative NEXT_DAY : Next day of the date specified NEXT_DAY(date, 'char') The value of char must be a number representing a day or a character string. LAST_DAY : Last day of the month L..

MONTHS_BETWEEN : NUmber of months between two dates MONTHS_BETWEEN(date1,date2) The result canbe positive or negative ADD_MONTHS : Add calendar months to date ADD_MONTHS(date, n) "n" must be an integer and can be negative NEXT_DAY : Next day of the date specified NEXT_DAY(date, 'char') The value of char must be a number representing a day or a character string. LAST_DAY : Last day of the month L..

UNDEFINE employee_num Use the double ampersand(&&) if you wantto reuse the ariable value without prompting the user each time: SELECT employee_id, last_name, job_id, &&column_name FROM employees ORDER BY &column_name Use DEFINE command to create and assign a value to a variable Use UNDEFINE command to remove a variable DEFINE employee_num = 200 SELECT employee_id,last_name, salary, department_id..

UNDEFINE employee_num Use the double ampersand(&&) if you wantto reuse the ariable value without prompting the user each time: SELECT employee_id, last_name, job_id, &&column_name FROM employees ORDER BY &column_name Use DEFINE command to create and assign a value to a variable Use UNDEFINE command to remove a variable DEFINE employee_num = 200 SELECT employee_id,last_name, salary, department_id..

single-ampersand(&) or double-ampersand(&&) & : temporary && : Use subtitution variables to supplement the following - WHERE condition - ORDER BY clause - Column expressions - Table names - Entire SELECT statements Predefine variables by using DEFINE

single-ampersand(&) or double-ampersand(&&) & : temporary && : Use subtitution variables to supplement the following - WHERE condition - ORDER BY clause - Column expressions - Table names - Entire SELECT statements Predefine variables by using DEFINE

Sorting in descending order SELECT last_name,job_id,department_id, hire_date FROM employees ORDER BY hire_date DESC;Sorting by column alias SELECT employee_id,last_name,salary*12 annsal FROM employees ORDER BY annsal;Sorting by multiple columns SELECT last_name,department_id,salary FROM employees ORDER BY department_id,salary DESC; - NULL values are displayed last for ascending sequences and fir..

Sorting in descending order SELECT last_name,job_id,department_id, hire_date FROM employees ORDER BY hire_date DESC;Sorting by column alias SELECT employee_id,last_name,salary*12 annsal FROM employees ORDER BY annsal;Sorting by multiple columns SELECT last_name,department_id,salary FROM employees ORDER BY department_id,salary DESC; - NULL values are displayed last for ascending sequences and fir..