FilesExpand file tree

master

/

orafce--4.12--4.13.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

22 lines (19 loc) · 687 Bytes

master

/

orafce--4.12--4.13.sql

Copy path

Top

File metadata and controls

• Code
• Blame

22 lines (19 loc) · 687 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

-- remove obsolete signature of dbms_alert.defered_signal

DO $$

BEGIN

IF EXISTS (SELECT *

FROM pg_proc p

JOIN pg_namespace n ON p.pronamespace = n.oid

WHERE n.nspname = 'dbms_alert' AND p.proname = 'defered_signal') THEN

DROP FUNCTION dbms_alert.defered_signal();

END IF;

END;

$$;

CREATE FUNCTION oracle.orafce__obsolete_to_date(str text, fmt text)

RETURNS timestamp

AS 'MODULE_PATHNAME','ora_to_date'

LANGUAGE C STABLE STRICT PARALLEL SAFE;

CREATE OR REPLACE FUNCTION oracle.to_date(TEXT, TEXT)

RETURNS oracle.date

AS $$ SELECT oracle.orafce__obsolete_to_date($1, $2)::oracle.date; $$

LANGUAGE SQL STABLE STRICT PARALLEL SAFE;