Untitled

create or replace function abd
return varchar as
c varchar(20);
begin
select address into c from students where name='neethu';
return c;
end abd;
/
declare
c varchar(20);
begin
c:=abd();
dbms_output.put_line('Address ='||c);
end;
/