{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Report

{[ snackBarMessage ]}