Advertisement
Guest User

Pt danutz

a guest
Oct 24th, 2014
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. select first_name "Numele", last_name "Prenumele", round(trunc(months_between(sysdate,hire_date))/12,1) "Anii de lucru" , hire_date "Data Angajarii", sysdate "Data actuala" from employees
  2.  
  3. select trunc(sysdate-to_date('03_Jan-1997','dd-Mon-yyyy')) "Am trait atatea zile" from dual
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement