An easy technique to visualize data in LOV's like this:
Use multiple UNION ALL's to concatenate the data :
Use multiple UNION ALL's to concatenate the data :
select '---new colleagues---' ename, NULL job, NULL hiredate from dual UNION ALL select ename, job, to_char (hiredate, 'DD.MM.YYYY') from emp where hiredate >= to_date ('01.07.1981', 'DD.MM.YYYY') UNION ALL select '---before 07/81---' ename, NULL job, NULL hiredate from dual UNION ALL select ename, job, to_char (hiredate, 'DD.MM.YYYY') from emp where hiredate < to_date ('01.07.1981', 'DD.MM.YYYY')
No comments:
Post a Comment