Technical Development - Tiveloper.

TIMESTAMP : Date with fractional second INTERVAL YEAR TO MONTH : Stored as an interval of years and months INTERVAL DAY TO SECOND : Stored as an interval of days, hours, minutes and seconds Representing the Difference Between Datetime ValuesUse the INTERVAL DAY TO SECOND datatype to represent the precise difference between two datetime values. For example, you might use this value to set a remin..

COLUMN a_dummy NOPRINT SELECT 'sing' AS "My Dream", 3 a_dummy FROM dual UNION SELECT 'I''d like to teach', 1 a_dummy FROM dual UNION SELECT 'the world to', 2 a_dummy FROM dual ORDER BY a_dummy; ORDER BY clause can be used only once in a compound query and it should be placed at the very end of the query. COLUMN : You can use this command to customized column headings.

COLUMN a_dummy NOPRINT SELECT 'sing' AS "My Dream", 3 a_dummy FROM dual UNION SELECT 'I''d like to teach', 1 a_dummy FROM dual UNION SELECT 'the world to', 2 a_dummy FROM dual ORDER BY a_dummy; ORDER BY clause can be used only once in a compound query and it should be placed at the very end of the query. COLUMN : You can use this command to customized column headings.

select department_id,TO_NUMBER(null) location, hire_date from employees union select department_id, location_id, TO_DATE(null) hired from departments In this example, the name location is given as the dummy column heading. The TO_NUMBER function is used in the first query to match the NUMBER data type of the LOCATION_ID column retrieved by the second query. Similary, the TO_DATE function in the ..

select department_id,TO_NUMBER(null) location, hire_date from employees union select department_id, location_id, TO_DATE(null) hired from departments In this example, the name location is given as the dummy column heading. The TO_NUMBER function is used in the first query to match the NUMBER data type of the LOCATION_ID column retrieved by the second query. Similary, the TO_DATE function in the ..

SELECT employee_id, department_id FROM employee_id WHERE (employee_id, department_id) IN(SELECT employee_id, department_id FROM employees {UNION|UNION ALL|INTERSECT|MINUS} SELECT employee_id, department_id FROM job_history);

SELECT employee_id, department_id FROM employee_id WHERE (employee_id, department_id) IN(SELECT employee_id, department_id FROM employees {UNION|UNION ALL|INTERSECT|MINUS} SELECT employee_id, department_id FROM job_history);