12123

DECLARE
v_person_name sal.name%TYPE := 'John Doe'; -- Change to the name you want to search
v_count INTEGER := 0;
v_salary sal.salary%TYPE;
BEGIN
-- Check for duplicate entries
SELECT COUNT(*)
INTO v_count
FROM sal
WHERE name = v_person_name;

IF v_count > 1 THEN
    -- Display message for duplicate entries
    DBMS_OUTPUT.PUT_LINE('Duplicate entries found for name ' || v_person_name);
ELSIF v_count = 1 THEN
    -- Retrieve details of the person
    SELECT salary
    INTO v_salary
    FROM sal
    WHERE name = v_person_name;

    -- Display person's details
    DBMS_OUTPUT.PUT_LINE('Name: ' || v_person_name);
    DBMS_OUTPUT.PUT_LINE('Salary: ' || v_salary);
ELSE
    -- Handle case where no entries found
    DBMS_OUTPUT.PUT_LINE('No entries found for name ' || v_person_name);
END IF;

EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('No entries found for name ' || v_person_name);
END;
/