Advertisement
lucasmouraahere

Função Oracle ROUND

Jun 27th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.61 KB | None | 0 0
  1. SELECT first_name,
  2.        salary / 2.7,
  3.  ROUND(salary / 2.7) AS ROUND,
  4.   FROM hr.employees
  5.  WHERE job_id ='IT_PROG';
  6.  
  7. SELECT first_name,
  8.        salary / 2.7,
  9.  ROUND(salary / 2.7, 2) AS ROUND
  10.   FROM hr.employees
  11.  WHERE job_id ='IT_PROG';
  12.  
  13. SELECT first_name,
  14.        hire_date,
  15.  ROUND(hire_date, 'MONTH') AS ROUND
  16.   FROM hr.employees
  17.  WHERE job_id ='IT_PROG';
  18.  
  19. SELECT first_name,
  20.        hire_date,
  21.  ROUND(hire_date, 'DAY') AS ROUND
  22.   FROM hr.employees
  23.  WHERE job_id ='IT_PROG';
  24.  
  25. SELECT first_name,
  26.        hire_date,
  27.  ROUND(hire_date, 'YYYY') AS ROUND
  28.   FROM hr.employees
  29.  WHERE job_id ='IT_PROG';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement