19 noiembrie

Departamente, suma salariilor din fiecare, media, max si min din fiecare plus numarul de angajati
select department_name, sum(salary), trunc(avg(salary)), min(salary),max(salary),count(*) angajati from employees join departments using (department_id) group by department_name

select add_months(to_date('01-01-2012','dd-mm-yyyy'),4) from dual

select add_months(to_date('2012/02/02','yyyy-mm-dd'),4) from dual

select to_char(add_months(to_date('2012/02/02','yyyy-mm-dd'),4),'day,month,yyyy') from dual

Luna in cifre romane (rm sau RM)
select to_char(add_months(to_date('2012/02/02','yyyy-mm-dd'),4),'day,rm,yyyy') from dual