Oracle SQL concatenate multiple columns add text

Question

So I basically wanna display this  whole row in ONE column     I like  type column  cake with  icing column  and a  fruit column    The result should be   Cake Column ----------------  I like chocolate cake with whipped cream and a cherry   I like strawberry cake with vanilla cream and a lemon slice   etc   etc    I need some sort of TO CHAR statement that does   column   some text   column    new column name    What am I supposed to know

User · Answer

Below query works for me  Oracle 10G ----                select PHONE  CONTACT   ADDR1      -     ADDR2     -     ADDR3  as Address from CUSTOMER DETAILS where Code  341      O P -     1111 abc gmail com 4th street-capetown-sa

User · Answer

Did you try the    operator    Concatenation Operator Documentation from Oracle

User · Answer

You have two options for concatenating strings in Oracle    CONCAT Using      CONCAT example   CONCAT    CONCAT      CONCAT        CONCAT          CONCAT  I like    t type desc column              cake with            t icing desc column         and a       t fruit desc column    Using    example    I like      t type desc column      cake with      t icing desc column      and a      t fruit desc column

User · Answer

select  i like     type column      with  ect

User · Answer

Try this   SELECT  I like      type column name      cake with       icing column name      and a   fruit column name         AS Cake Column FROM your table name    It should concatenate all that data as a single column entry named  Cake Column

User · Answer

The Oracle PLSQL CONCAT function allows to concatenate two strings together   CONCAT  string1  string2        string1      The first string to concatenate       string2      The second string to concatenate    E g   SELECT  I like      type column name      cake with       icing column name      and a   fruit column name         AS Cake FROM table

[sql] Oracle SQL, concatenate multiple columns + add text

Examples related to sql

Examples related to oracle

Examples related to concatenation