Number Functions in Oracle
ROUND(45.926, 2) Result 45.93
TRUNC(45.926, 2) Result 45.92
MOD(1600, 300) Result 100
Using the MOD Function
SELECT last_name, salary, MOD(salary, 5000)
FROM employees
WHERE job_id = 'SA_REP';
FROM employees
WHERE job_id = 'SA_REP';
Using the TRUNC Function
SELECT TRUNC(45.923,2), TRUNC(45.923),
TRUNC(45.923,-1)
FROM DUAL;
TRUNC(45.923,-1)
FROM DUAL;
Using the ROUND Function
SELECT ROUND(45.923,2), ROUND(45.923,0),
ROUND(45.923,-1)
FROM DUAL;
ROUND(45.923,-1)
FROM DUAL;
Working with Dates
SELECT last_name, hire_date
FROM employees
WHERE hire_date < '01-FEB-88';
FROM employees
WHERE hire_date < '01-FEB-88';
Using Arithmetic Operators
with Dates
SELECT last_name, (SYSDATE-hire_date)/7 AS WEEKS
FROM employees
WHERE department_id = 90;
FROM employees
WHERE department_id = 90;
Using the TO_CHAR Function with Dates
SELECT last_name,
TO_CHAR(hire_date, 'fmDD Month YYYY')
AS HIREDATE
FROM employees;
TO_CHAR(hire_date, 'fmDD Month YYYY')
AS HIREDATE
FROM employees;
Using the TO_CHAR Function with Numbers
SELECT TO_CHAR(salary, '$99,999.00') SALARY
FROM employees
WHERE last_name = 'Ernst';
FROM employees
WHERE last_name = 'Ernst';
Implicit Data Type Conversion dalam ORACLE
VARCHAR2 or CHAR NUMBER to Number
VARCHAR2 or CHAR to Date
NUMBER to VARCHAR2
DATE to VARCHAR2
Tidak ada komentar:
Posting Komentar