Link to home
Start Free TrialLog in
Avatar of romeiovasu
romeiovasu

asked on

oracle concatenation in where clause

Hi All,

trying to create a query using
select datevalue, timestamp from numericlog
where namelog = functiona'||'functionb'||'functionc

when i tried to use this i am get an error saying
Multiple Query Filters contain a prompt with the same text, but different operand type or operator count of values

Can someone help me what i am missing over here.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

The single quotes look off for Oracle.

Maybe something like this:
 functiona||functionb||functionc

That isn't an Oracle message.
What tool/product are you using?
What are functiona, b and c?  Are they database functions?
Avatar of romeiovasu

ASKER

yes they are database functions.

In oracle lets say if i want to use concatenation how should i use in where clause.
even if remove single quotes i am still getting the same error
Multiple Query Filters contain a prompt with the same text, but different operand type or operator count of values
In oracle lets say if i want to use concatenation how should i use in where clause.
Same as in the query body, try removing the quotes.
:p
What tool are you using?

Can you run the query in sqlplus?
even if remove single quotes i am still getting the same error
as slightwv poited out that is not an Oracle error look it up in the reference manual  of the utility you are using.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial