SQL “Cover”

• Defines arguments conversion and SQL name

class Employee {

public static float yearsEmployed(Date d) {

return

(float) (new java.util.Date().getTime() - d.getTime()) /

(float) (1000 * 60 * 60 * 24 * 365.25);

}

}

CREATE OR REPLACE FUNCTION years_employed(d DATE) return NUMBER

AS LANGUAGE JAVA NAME

‘Employee.yearsEmployed(java.sql.Date) return float’;

Previous slide

Next slide

Back to first slide

View graphic version