Group Above Report for Oracle Apex & BI Publisher
#####################################
select e.department_id, department_name, employee_id, first_name||' '||last_name employee_name,
to_char(hire_date,'DD-Mon-RRRR')hire_date,
to_char(salary,'99,99,999.99') Salary
from employees e, departments d
where e.department_id = d.department_id
order by e.department_id
select distinct department_name, e.department_id
from employees e, departments d
where e.department_id = d.department_id
order by department_name
select e.department_id, department_name, employee_id, first_name||' '||last_name employee_name,
to_char(hire_date,'DD-Mon-RRRR')hire_date,
to_char(salary,'99,99,999.99') Salary
from employees e, departments d
where e.department_id = d.department_id
and e.department_id like nvl(:P2_DEPARTMENT_ID,'%')
order by e.department_id
f?p=&APP_ID.:0:&SESSION.:PRINT_REPORT=Group_Above_1
apex.oracle.co...
Негізгі бет Group Above Report for Oracle Apex & BI Publisher
Пікірлер: 6