ADF view object with bind parameter and like operator .

 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