25 Eylül 2014 Perşembe

REMAINDER FUNCTION,MOD FUNCTION

Remainder function does the same job with mod.
But valid for 10g,11g,12c

Mod function is valid for 8i,9i,10g,11g,12c database versions.

Some repetittions;

select abs(-10) from dual;

10

select ceil(1.3) from dual;

2

select floor(1.3) from dual;

1

select power(3,2) from dual;

9

select round(22.5) from dual;

23

select round (-22.5) from dual;

-23

select sign(-30) from dual;

-

Hiç yorum yok:

Yorum Gönder