GetSalary - BEGIN select sal into v_salary from emp where...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 --Get Salary for an employee number CREATE OR REPLACE FUNCTION GET_SAL (v_id in emp.empno%type) return number IS v_salary emp.sal%type := 0
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BEGIN select sal into v_salary from emp where empno = v_id return (v_salary) end get_sal...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online