This
preview
has intentionally blurred sections.
Sign up to view the full version.
Unformatted text preview: var DeptRecTyp begin var:=myfunc dbms_output.put_line(var.dname) dbms_output.put_line(var.deptno) dbms_output.put_line(var.loc) end / ___________________________________________________________________ Sheet1 Page 2 CREATE OR REPLACE FUNCTION MYFUNC RETURN emp_record_type IS TYPE emp_record_type IS RECORD (employee_id emp.empno%type, name emp.ename%TYPE, job_id emp.job%TYPE) emp_record emp_record_type BEGIN select empno,ename,job into emp_record from emp where empno=7369 dbms_output.put_line(emp_record.name) end...
View
Full Document
- Summer '10
- MR.RAZA
- Tuple, Category theory, function myfunc return, RECORD TYPE */, MYFUNC RETURN DeptRecTyp
-
Click to edit the document details