• Home
  • SQL & PL/SQL Guidelines
  • Publications / Talks
  • Videos
  • Monday Morning Tech Talk
  • About
  • Contact

Just another ORACLE Development blog

Just another ORACLE Development blog

Category Archives: Oracle 23c

ORACLE 23c – Concat with more than 2 parameters

18 Tuesday Apr 2023

Posted by troroblog in Oracle 23c

≈ Leave a comment

Tags

ORACLE

One of the Oracle 23c extensions that is not in the spotlight is the possibility to pass more than 2 parameters to the concat function. In previous versions of Oracle concat was limited to 2 parameters.

Syntax diagram up to version 21c:

concat21c

now with 23c the diagram looks like this:

concat23c


I have tried to call concat with 129, 257 and even 1001 parameters. Too me it looks like the number of parameters are only limited by the possible size of the resulting datatype.

select concat('A','B','C') as resulting_string

RESULTING_STRING
----------------
ABC

Disclaimer

The opinions I express on my blog are my own and not necessarily those of the company I am working for.

Archives

Tags

Analytic Functions CAST Compiler Error Compiler Warning CONNECT BY Data Conversion DATE DEFAULT FIRST_VALUE Identity Column LAST_VALUE LISTAGG Model Clause New Feature ORACLE ORACLE 11g Release 2 ORACLE 12c Release 1 ORACLE 12c Release 2 OUTER JOIN PL/SQL PRAGMA RECURSION Regular Expression ROUNDING Row Pattern Matching Sequence SQL TABIBITOSAN Top-N TO_CHAR TO_DATE TO_NUMBER Truncate Table VALIDATE_CONVERSION VALIDITY WM_CONCAT XMLAGG

Recent Posts

  • ORACLE 23c – Concat with more than 2 parameters
  • Antipatterns SQL & PL/SQL – Redefine oracle defined exceptions
  • ORA12R2 – IMPdp may change segment_column_id
  • Antipatterns SQL & PL/SQL – “SELECT *” even if you only need a few columns
  • Antipatterns SQL & PL/SQL – Substitute NULL with empty string

Blog at WordPress.com.

 

Loading Comments...