SQL函数
单行函数
-- 写一个查询显示当前日期,列标签显示为Date
select sysdate "Date" from dual;
/*对每一个雇员,显示employee number、last_name、salary和salary增加15%,
并且表示成整数,列标签显示为New Salary*/
select employee_id, last_name, salary, round(salary * (1.15)) "New Salary" from employees;
select initcap( last_name) , length( last_name) from employees where substr( last_name, 1 , 1 ) in ( 'J' , 'A' , 'M' ) order by last_name;
select last_name, round ( months_between( sysdate, hire_date) ) MONTHS_WORKED from employees order by MONTHS_WORKED;
select last_name || ' earns ' || to_char( salary, 'fm$999,999,999.99' ) || ' monthly but wants ' || to_char( salary * 3 , 'fm$999,999,999.99' ) "Dream Salaries" from employees;
select last_name, lpad( salary, 15 , '$' ) SALARY from employees;
select last_name, to_char( hire_date, 'yyyy"年"mm"月"dd"日" day' ) , next_day( hire_date, '星期日' ) DAY from employees order by to_char( hire_date- 1 , 'd' ) ;
select last_name, nvl( to_char( commission_pct) , 'No Commission' ) COMM from employees;