The social network for Oracle people
LIKE clause in Strored Procedures
How would you define a variable in a Stored procedure when using the LIKE clause ie.
EXEX curt @value = '100'
select * from table where username like '%?????
username have values of (K100, J100, T100, etc )
Does not seems to work no matter how I try to put the variable in the LIKE clause.
EXEX curt @value = '100'
select * from table where username like '%?????
username have values of (K100, J100, T100, etc )
Does not seems to work no matter how I try to put the variable in the LIKE clause.
Replies to This Discussion
-
Permalink Reply by Eddie Awad on -
How about this:
select * from table where username like '%' || variable_name || '%';
About
Oracle Community On
Oracle Blogosphere
Badge
© 2010 Created by Eddie Awad on Ning. Create a Ning Network!
