Welcome to maiiavril blogspot

Jumat, 12 Oktober 2012

Number Functions in Oracle

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';

Using the TRUNC Function

SELECT TRUNC(45.923,2), TRUNC(45.923),
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;

Working with Dates

SELECT last_name, hire_date
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;
 


Using the TO_CHAR Function with Dates 

SELECT last_name,
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'; 


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