Name: | RESIGN_EMPLOYEE |
Schema: | USER |
Definer: | USER |
Specific name: | SQL060624144124500 |
Valid: | |
Create time: | 24.06.2006 |
Alter time: | 24.06.2006 |
Qualifier: | USER |
Determenistic: | |
Language: | SQL |
Description: |
Name | Direction | Type | Length | Scale | Codepage | Description | |
|
EMPNO | BEFORE CASTING | CHARACTER | 6 | 0 | 1251 | |
|
NUMBER | IN | CHARACTER | 6 | 0 | 1251 | |
|
SALARY | BEFORE CASTING | DOUBLE | 8 | 0 | 0 | |
|
DEPT | BEFORE CASTING | CHARACTER | 3 | 0 | 1251 |
CREATE FUNCTION resign_employee (number CHAR(6))
RETURNS TABLE (empno CHAR(6),
salary DOUBLE,
dept CHAR(3))
MODIFIES SQL DATA
LANGUAGE SQL
BEGIN ATOMIC
DECLARE l_salary DOUBLE;--
DECLARE l_job CHAR(3);--
RETURN VALUES (number,l_salary, l_job);--
END
See Also
List of functions