Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
In the concurrent program parameter, Is there a way to search based on both employee name and employee number ? I tried using the value set but it's only allowing to search based on the VALUE column in the value set.
Thanks for your help.
Try in the following way.
Table Name = (SELECT EMP_NUMBER ||' '||EMP_NAME EMP_CODE FROM EMPMST) X
Value = X.EMP_CODE