sallam

please how to do massgae alert for appointment to dental doctors

the alert must be when the same doctor name have to patient in the same time( we have more than doctor in the center) when the secrtary take appointment for

tow patient at the same time

the alert massage appear


please help

try using count function that you can know like this example

declare
x number;
begin select count(*) into x from patient where patient_name=:patient_name and doctor_name=:doctor_name;
if x>1 then
message('no your message');
else
null;
end if;
end;

try to solve problem like the previous example

thank you

I Will try it