What is the string concatenation operator in Oracle

Question

What is the string concatenation operator in Oracle SQL     Are there any  interesting  features I should be careful of      This seems obvious  but I couldn t find a previous question asking it

User · Answer

DECLARE      a      VARCHAR2 30        b      VARCHAR2 30        c      VARCHAR2 30    BEGIN       a       Abc           b       def          c     a    b   DBMS OUTPUT PUT LINE c        END    output   Abc  def

User · Answer

It is     for example   select  Mr      ename from emp    The only  interesting  feature I can think of is that  x     null returns  x   not null as you might perhaps expect

User · Answer

Using CONCAT CONCAT      worked for me when concatenating more than two strings    My problem required working with date strings  only  and creating YYYYMMDD from YYYY-MM-DD as follows  i e  without converting to date format    CONCAT CONCAT SUBSTR DATECOL 1 4  SUBSTR DATECOL 6 2   SUBSTR DATECOL 9 2   AS YYYYMMDD

User · Answer

Using CONCAT CONCAT      worked for me when concatenating more than two strings    My problem required working with date strings  only  and creating YYYYMMDD from YYYY-MM-DD as follows  i e  without converting to date format    CONCAT CONCAT SUBSTR DATECOL 1 4  SUBSTR DATECOL 6 2   SUBSTR DATECOL 9 2   AS YYYYMMDD

User · Answer

It is     for example   select  Mr      ename from emp    The only  interesting  feature I can think of is that  x     null returns  x   not null as you might perhaps expect

User · Answer

I would suggest concat when dealing with 2 strings  and    when those strings are more than 2   select concat a b    from dual   or    select  a    b    c    d          from dual

User · Answer

It is     for example   select  Mr      ename from emp    The only  interesting  feature I can think of is that  x     null returns  x   not null as you might perhaps expect

User · Answer

There s also concat  but it doesn t get used much  select concat  a   b   from dual

User · Answer

There s also concat  but it doesn t get used much  select concat  a   b   from dual

User · Answer

It is     for example   select  Mr      ename from emp    The only  interesting  feature I can think of is that  x     null returns  x   not null as you might perhaps expect

User · Answer

There s also concat  but it doesn t get used much  select concat  a   b   from dual

User · Answer

I would suggest concat when dealing with 2 strings  and    when those strings are more than 2   select concat a b    from dual   or    select  a    b    c    d          from dual

User · Answer

DECLARE      a      VARCHAR2 30        b      VARCHAR2 30        c      VARCHAR2 30    BEGIN       a       Abc           b       def          c     a    b   DBMS OUTPUT PUT LINE c        END    output   Abc  def

User · Answer

There s also concat  but it doesn t get used much  select concat  a   b   from dual

[sql] What is the string concatenation operator in Oracle?

Examples related to sql

Examples related to oracle

Examples related to plsql

Examples related to string-concatenation