Concat function has not be run in Oracle SQL developer [duplicate]

Question

When I run my whole SQL query then I got an error. CONCAT() function has not be run while execution:

..... concat(cast(col1 as varchar2(10)),'-', col2) = 'value'

Below this one is part of the query but I stuck on this line only. Why Concat function has not be run.

Bikash Ranjan Bhoi · Accepted Answer · 2017-12-01 14:24:28Z

1

CONCAT function takes only 2 arguments. You must be getting invalid number of Arguments here.

Use

... col1||'-'||col2 = 'value'....

No need to explicitly cast your variable here. Oracle will implicitly handle this.

answered Dec 1, 2017 at 14:24

5142 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1