Oracle PL/SQL 學習筆記

1
2
3
4
5
6
7
8
9

if a > b then
  t := 0;
elsif
  a > c
then
  t := 1;
else
  t := 2;
end if;

1
2
3
4
5
6
7
8
9

LOOP

    ...

    V_LOOP_CONT := V_LOOP_CONT +1 ;
    IF V_TOTAL_LOOP_CONT <= V_LOOP_CONT THEN 
        EXIT; 
    END IF;
  END LOOP;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

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;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

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;