Concat function is not working – invalid number of arguments

by 
SELECT CONCAT(Name,"(",SUBSTR(Occupation,1,1),")") FROM OCCUPATIONS;

First, the double quotes " are used to enclose identifiers. use single quote ' to wrap a string.

Second, CONCAT accepts two params.

You could nest bunch of concats, but it’s easier and cleaner to use concatenation operation ||:

SELECT Name || '('  || SUBSTR(Occupation,1,1) || ')' FROM OCCUPATIONS;

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Fetch the rows which have the Max value for a column for each distinct value of another column
  8. REGEX to select nth value from a list, allowing for nulls
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Difference between BYTE and CHAR in column datatypes
  11. Call a stored procedure with another in Oracle
  12. create table with sequence.nextval in oracle [duplicate]
  13. Oracle: loading a large xml file?
  14. IF EXISTS condition not working with PLSQL
  15. Group by alias (Oracle)
  16. Using pivot on multiple columns of an Oracle row
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. Split comma separated values of a column in row, through Oracle SQL query
  20. oracle — Split multiple comma separated values in oracle table to multiple rows
  21. How to query a CLOB column in Oracle
  22. update columns values with column of another table based on condition [duplicate]
  23. how to select even records from a table in oracle?
  24. Oracle : select maximum value from different columns of the same row
  25. Split varchar into separate columns in Oracle
  26. Creating or simulating two dimensional arrays in PL/SQL
  27. Using Alias In When Portion of a Case Statement in Oracle SQL
  28. Oracle string aggregation
  29. How do NULL values affect performance in a database search?
  30. Check if two “select”s are equivalent

Leave a Comment