Codecreate or replace procedure GetSingle(a in varchar2, b out varchar2) asbegin select title into b from log where id = a; --查询根据密码返回姓名end GetSingle;