employee_service

Functions, procedures

function get_employee_name 

function get_employee_name(
    p_empno in number
) return varchar2

function get_employee 

function get_employee(
    p_empno in number
) return emp%rowtype

function get_employees 

function get_employees(
    p_search_filter in varchar2
) return clob

procedure some_procedure 

procedure some_procedure(
    p_param1 in varchar2
)

function new_employee 

function new_employee(
    p_ename in varchar2
) return number

function get_employees_by_date 

function get_employees_by_date(
    p_from_date in date,
    p_to_date in date
) return clob

function no_input_parameters 

function no_input_parameters return varchar2

function get_first_hire_date 

function get_first_hire_date return date