Answers for "create function in oracle"

SQL
3

oracle function

CREATE OR REPLACE FUNCTION to_date_check_null(dateString IN VARCHAR2, 
	dateFormat IN VARCHAR2) RETURN DATE IS
BEGIN 
    IF dateString IS NULL THEN
        return NULL;
    ELSE
        return to_date(dateString, dateFormat);
    END IF;
END;
Posted by: Guest on August-15-2021
1

syntax of function in oracle

CREATE [OR REPLACE] FUNCTION function_name
   [ (parameter [,parameter]) ]

   RETURN return_datatype

IS | AS

   [declaration_section]

BEGIN
   executable_section

[EXCEPTION
   exception_section]

END [function_name];
Posted by: Guest on March-20-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language