判斷式 if else
if a > b then
t := 0;
elsif
a > c
then
t := 1;
else
t := 2;
end if;
迴圈
LOOP
...
V_LOOP_CONT := V_LOOP_CONT +1 ;
IF V_TOTAL_LOOP_CONT <= V_LOOP_CONT THEN
EXIT;
END IF;
END LOOP;
package
CREATE OR REPLACE PACKAGE PK_1 AS
/******************************************************************************
NAME: PK_1
PURPOSE: PK_1
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2024-03-13 PolloChang 1. 初次新增
******************************************************************************/
FUNCTION FUNCTION_NAME_1 (P_VAL IN VARCHAR2) RETURN VARCHAR2;
END PK_1;
CREATE OR REPLACE PACKAGE PK_1 AS
/******************************************************************************
NAME: PK_1
PURPOSE: PK_1
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2024-03-13 PolloChang 1. 初次新增
******************************************************************************/
FUNCTION FUNCTION_NAME_1 (P_VAL IN VARCHAR2) RETURN VARCHAR2
AS
V_RETUREVAL VARCHAR2(1000);
begin
V_RETUREVAL := '';
...
return V_RETUREVAL;
end;
END PK_1;
參考資料
