The short answer is that a VIEW is just a static representation of tabular data – and cannot accept a parameter. However, one can accomplish the same thing by doing passing the parameter in the QUERY after creating the view…

VIEW

create view v_emp as select * from emp ;

Query

select * from v_emp where emp_id=&eno;

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.