create or replace procedure check_password(name varchar2,pass varchar2)
is
cursor cur_pass is
select count(*) from mylogin
where name=name and password=pass;
begin
for i in cur_pass(name,pass) loop
dbms_output.put_line('password valid');
end loop;
end;
is
cursor cur_pass is
select count(*) from mylogin
where name=name and password=pass;
begin
for i in cur_pass(name,pass) loop
dbms_output.put_line('password valid');
end loop;
end;
is
n integer;
begin
select count(*) into n from mylogin
where name = n and password = p;
if n = 0 then
dbms_output.put_line('password invalid');
else
dbms_output.put_line('password valid');
end if;
end;