What is the string concatenation operator in Oracle?

by

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.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. PL SQL UPDATE STATEMENT
  3. Search All Fields In All Tables For A Specific Value (Oracle)
  4. Is there a combination of “LIKE” and “IN” in SQL?
  5. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  6. Is it possible to output a SELECT statement from a PL/SQL block?
  7. REGEX to select nth value from a list, allowing for nulls
  8. SQL to generate a list of numbers from 1 to 100
  9. How to use BOOLEAN type in SELECT statement
  10. SQL recursive query on self referencing table (Oracle)
  11. How can you tell if a value is not numeric in Oracle?
  12. create table with sequence.nextval in oracle [duplicate]
  13. IF EXISTS condition not working with PLSQL
  14. PLS-00428: an INTO clause is expected in this SELECT statement
  15. SQL error “ORA-01722: invalid number”
  16. WHERE IN condition not accepting String value
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. Array in IN() clause oracle PLSQL
  20. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  21. How to query a CLOB column in Oracle
  22. Oracle (Old?) Joins – A tool/script for conversion?
  23. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  24. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  25. Creating or simulating two dimensional arrays in PL/SQL
  26. How to handle optional parameters in SQL query?
  27. How to check if a column exists before adding it to an existing table in PL/SQL?
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. How to call Oracle MD5 hash function?
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment