Monday, November 5, 2007

1.DISPLAY THE NAME AND SALARY FROM EMPLOYEE TABLE

declare
n vachar(10);
s number(10);
begin
select ename, sal into n,s from emp where eno=&eno;
dbms_output.put_line('name is ' ||n|| 'and salary is' ||s );
end;

No comments: