/* working with anochard datatype*/
declare
eno emp.empno%type;
ena emp.ename%type;
jb emp.job%type;
salary emp.sal%type;
begin
select empno, ename , job , sal into eno , ena , jb , salary from emp where empno = '&eno';
dbms_output.put_line('empno = ' || eno || 'ename = ' || ena || 'job = ' || jb || 'salary = ' || salary);
end;
/
Tuesday, March 24, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment