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.
trying to create a query using
select datevalue, timestamp from numericlog
where namelog = functiona'||'functionb'||'
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.
ASKER
yes they are database functions.
In oracle lets say if i want to use concatenation how should i use in where clause.
In oracle lets say if i want to use concatenation how should i use in where clause.
ASKER
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
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?
Can you run the query in sqlplus?
even if remove single quotes i am still getting the same erroras 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe something like this:
functiona||functionb||func
That isn't an Oracle message.
What tool/product are you using?
What are functiona, b and c? Are they database functions?