For your scenario, I would follow the below steps to achieve the expected result:
1. Create the Netezza base view as you performed, but without the namelist parameter(@name_list)
2. Create the Oracle base view as you performed
3. Join the above two views using the condition on the name field (name = name_list) to pull the matching data. If I need to pull only specific names, I would add the filter condition to this view.
I would further extend the join operations for further processing of data(if required).
For more information, please refer the sections [Creating Derived Views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_derived_views) and [Creating Join Views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views) of the Virtual Dataport Administration Guide.
Hope this helps!