CONCATENATING TEXT : Select « Select Query « Oracle PL / SQL

1. Oracle PL / SQL
2. Select Query
3. Select

CONCATENATING TEXT

   
SQL>
SQL> CREATE TABLE purchase (
  2       product_name  VARCHAR2(25),
  3       product_price NUMBER(4,2),
  4       sales_tax     NUMBER(4,2),
  5       purchase_date DATE,
  6       salesperson   VARCHAR2(3));

Table created.

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

1 row created.

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

1 row created.

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

1 row created.

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

1 row created.

SQL>
SQL>
SQL> SELECT product_name || ' was sold by ' || salesperson FROM   purchase;

PRODUCT_NAME||'WASSOLDBY'||SALESPERSON
-----------------------------------------
Product Name 1 was sold by AB
Product Name 2 was sold by CD
Product Name 3 was sold by EF
Product Name 4 was sold by GH

4 rows selected.

SQL>
SQL>
SQL>
SQL> DROP TABLE purchase;

Table dropped.

SQL>
SQL>
SQL>

   
    
  

Related examples in the same category