Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

EXPIRED_P

Arguments:

NameData TypeDefault ValueIn/Out
EXPIRATION_DATEDATE IN

Returns:

VARCHAR2

Source

Source
     1: function expired_p(expiration_date in date) return varchar
     2: is
     3: begin
     4: 	IF expiration_date is null THEN
     5:             return 'f';
     6:         ELSIF expiration_date >= sysdate THEN
     7:             return 'f';
     8: 	ELSE
     9: 	    return 't';
    10: 	END IF;
    11: end;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002