select * from t1; id == 100 200 300 400 500 I want a procedure to get an input and check whether the given input values is found in column ID or not. If it is found then output should be FOUND else NOT FOUND. Plz give me the procedure. I tried in many ways. Gotten difference answers but not the desired one. Plz help as I am new to plsql.