Oracle parameters in c# inline query with wildcard

Question

I am having trouble using parameters for my in line oraclae query in c#. Why does the parameter not work within the wildcard?

This line returns no results:

Select id, name from Users where UPPER(name) like '%:name%'
command.Parameters.Add("name", OracleDbType.Varchar2, name.ToUpper(), ParameterDirection.Input);

But this returns:

Select id, name from Users where UPPER(name) like '%" + name.ToUpper() +"%'

Possible duplicate of: stackoverflow.com/questions/19730941/… Check there, see if that answers your problem. — guildsbounty
– guildsbounty, Commented Mar 18, 2015 at 14:38

Prabhat G · Accepted Answer · 2018-03-06 05:53:51Z

1

Did you mean this?

Select id, name 
from Users 
where UPPER(name) like '%' ||:name.ToUpper()||'%'

This concatenates your C# variable and the Oracle wildcard characters.

edited Mar 6, 2018 at 5:53

Prabhat G

3,0492 gold badges27 silver badges32 bronze badges

answered Mar 18, 2015 at 14:56

kevinskio

4,5711 gold badge27 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Oracle parameters in c# inline query with wildcard

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related