Função Oracle ROUND

Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ROUND faz o arredondamento dos valores e ela pode receber como parâmetro principal de entrada tanto um campo do tipo NUMBER como um DATE! SELECT first_name, salary / 2.7, round(salary / 2.7) AS ROUND, FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, salary / 2.7, round(salary / 2.7, 2) AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'MONTH') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'DAY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'YYYY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p