Plus two number type columns together : Number « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Number

SQL>
SQL>
SQL>
SQL>
SQL> CREATE TABLE myTable (
  2       name  VARCHAR2(25),
  3       price NUMBER(4,2),
  4       sales_tax     NUMBER(4,2),
  5       start_date DATE,
  6       salesperson   VARCHAR2(3));

Table created.

SQL>
SQL> INSERT INTO myTable VALUES ('Product Name 1', 1, .08, '5-NOV-04', 'AB');

1 row created.

SQL> INSERT INTO myTable VALUES ('Product Name 2', 2.5, .21, '29-JUN-05', 'CD');

1 row created.

SQL> INSERT INTO myTable VALUES ('Product Name 3', 50.75, 4.19, '10-DEC-06', 'EF');

1 row created.

SQL> INSERT INTO myTable VALUES ('Product Name 4', 99.99, 8.25, '31-AUG-07', 'GH');

1 row created.

SQL> SELECT * FROM myTable;


NAME                           PRICE  SALES_TAX START_DAT SAL
------------------------- ---------- ---------- --------- ---
Product Name 1                     1        .08 05-NOV-04 AB
Product Name 2                   2.5        .21 29-JUN-05 CD
Product Name 3                 50.75       4.19 10-DEC-06 EF
Product Name 4                 99.99       8.25 31-AUG-07 GH

4 rows selected.

SQL> SELECT name, price + sales_tax FROM myTable;


NAME                      PRICE+SALES_TAX
------------------------- ---------------
Product Name 1                       1.08
Product Name 2                       2.71
Product Name 3                      54.94
Product Name 4                     108.24

4 rows selected.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>