Oracle Magazine, Jan/Feb 2018
Database Developer PL SQL ORACLE MAGAZINE JANUARY FEBRUARY 2018 81 FUNCTION name_ from_ table1_ id id_ in IN INTEGER RETURN VARCHAR2 AUTHID DEFINER IS l_ the_ name table1 the_ name TYPE BEGIN SELECT the_ name INTO l_ the_ name FROM table1 WHERE id id_ in RETURN l_ the_ name END FUNCTION name_ from_ table2_ id id_ in IN INTEGER RETURN VARCHAR2 AUTHID DEFINER IS l_ the_ name table2 the_ name TYPE BEGIN SELECT the_ name INTO l_ the_ name FROM table2 WHERE id id_ in
You must have JavaScript enabled to view digital editions.