Cansoracle游标实用经典例子.docVIP

C9ans 8.根据下面表结构，完成如下任务 USERINFO(USERID,USERNAME,USERCODE,PASSWORD,PHONE,MAIL,TIME,ENABLED) 1.编写存储过程 CHECKLOGIN(usercode in varchar2,password in varchar2)用于执行身份验证判断登录，看usercode和password是否和数据库中的值一样。 create or replace procedure CHECKLOGIN(usercode in varchar2,password in varchar2)  as ps varchar2(20) ;begin select passwored into ps from USERINFO where USERINFO.usercode=usercode; if(ps=passwored) then dbms_output.put_line(login ok!); else dbms_output.put_line(login fail!); end if;end CHECKLOGIN;declarebegin CHECKLOGIN(4,123);end; create or replace procedure CHECKLOGI(us