Contents

{{works with|Oracle}}

-- test.sql
-- Tested in SQL*plus

drop table test;

create table test (a integer, b integer);

insert into test values ('&&A','&&B');

commit;

select a-b difference from test;

select a*b product from test;

select trunc(a/b) integer_quotient from test;  

select mod(a,b) remainder from test;

select power(a,b) exponentiation from test;



SQL> @test.sql

Table dropped.


Table created.

Enter value for a: 3
Enter value for b: 4
old   1: insert into test values ('&&A','&&B')
new   1: insert into test values ('3','4')

1 row created.


Commit complete.


DIFFERENCE
----------
        -1


   PRODUCT
----------
        12


INTEGER_QUOTIENT
----------------
               0


 REMAINDER
----------
         3


EXPONENTIATION
--------------
            81
   

Version data entries

10 entries across 7 versions & 1 rubygems

Version	Path
zettacode-0.1.7	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.6	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.6	files.zettacode2/arithmetic.integer/sql.txt
zettacode-0.1.5	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.5	files.zettacode2/arithmetic.integer/sql.txt
zettacode-0.1.4	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.4	files.zettacode2/arithmetic.integer/sql.txt
zettacode-0.1.3	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.2	files.zettacode/arithmetic.integer/sql.txt
zettacode-0.1.1	zettacode.files/arithmetic.integer/sql.txt