Requirement:
In this post i am explaining how to create ADF view object with like operator and bind parameter in where clause. requirement is very simple get all rows from employee table with employee containing runtime value entered by user.
In this case while we create new object in Jdeveloper give query as below
Query here is -
select EMPLOYEE_NAME,EMPLOYEE_ID from EMPLOYEE
where ( (UPPER(EMPLOYEE_NAME) LIKE UPPER('%' || :pEmployeeName || '%') )
In the next screen give bind parameter pEmployeeName of type string as below
After this pass the bind parameter from UI as user entered value .Hope this helps
