Hi,
I want to use parameter and would like get result like this
I have access file that has linked tables of oracle database.
I am trying to create prameter but oracle doesn't like named parameter so I am trying to use " ? " as parameter.
I have query similier to following:
select user_NM, user_Id, Address
from user
where user_NM like ?
but it doesn't work that way. how can i put ? or parameter to act such i can look for any thing such as if i type A then it should give me everything with starting or has A in name?
thanks
Thanks!!
I want to use parameter and would like get result like this
I have access file that has linked tables of oracle database.
I am trying to create prameter but oracle doesn't like named parameter so I am trying to use " ? " as parameter.
I have query similier to following:
select user_NM, user_Id, Address
from user
where user_NM like ?
but it doesn't work that way. how can i put ? or parameter to act such i can look for any thing such as if i type A then it should give me everything with starting or has A in name?
thanks
Thanks!!