Query Database Using Transformation and Assign

Query Database In Transformation:

In Transformation drag drop oraext:query-database





Double click the function and enter the details as below.





From source view it looks like below.



Query Database In Assign:





In Database the query results as follows



Testing the above service also results the same,

Thank You!!!!

Happy Learning!!!!