- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
CREATE FUNCTION get_date RETURN DATE
IS
BEGIN
RETURN SYSDATE;
END;
DECLARE
v_date DATE;
v_dummy VARCHAR2(2);
BEGIN
v_date := SYSDATE+4/24/60/60;
SELECT MAX(dummy)
INTO v_dummy
FROM dual
connect BY v_date > get_date;
END;