René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

sin, asin, sinh, cos, acos, cosh, tan, tanh [Oracle SQL]

sin(n)
asin(n)
sinh(n)
cos(n)
acos(n)
cosh(n)
tan(n)
tanh(n)
create table trigonometric(n number);

insert into trigonometric values( 0                   );
insert into trigonometric values( 1                   );
insert into trigonometric values( 1.570796326794896619);
insert into trigonometric values( 3.141592653589793238);
insert into trigonometric values(-1                   );
insert into trigonometric values(-1.570796326794896619);
insert into trigonometric values(-3.141592653589793238);

set lines    190
set numwidth   9

select          n    ,
       sin (    n   ),
       asin(mod(n,1)),
       sinh(    n)   ,
       cos (    n)   ,
       acos(mod(n,1)),
       cosh(    n)   ,
       tan (    n)   ,
       tanh(    n)
 from  trigonometric;
        N    SIN(N) ASIN(MOD(N,1))   SINH(N)    COS(N) ACOS(MOD(N,1))   COSH(N)    TAN(N)   TANH(N)
--------- --------- -------------- --------- --------- -------------- --------- --------- ---------
        0         0              0         0         1      1.5707963         1         0         0
        1 .84147098              0 1.1752012 .54030231      1.5707963 1.5430806 1.5574077 .76159416
1.5707963         1      .60747537 2.3012989 2.313E-19      .96332096 2.5091785 4.323E+18 .91715234
3.1415927 4.626E-19      .14207009 11.548739        -1      1.4287262 11.591953 -4.63E-19 .99627208
       -1  -.841471              0 -1.175201 .54030231      1.5707963 1.5430806 -1.557408 -.7615942
-1.570796        -1      -.6074754 -2.301299 2.313E-19      2.1782717 2.5091785 -4.32E+18 -.9171523
-3.141593 -4.63E-19      -.1420701 -11.54874        -1      1.7128664 11.591953 4.626E-19 -.9962721