create or replace function XXXXXXXXXXX(PVENDOR_ID IN VARCHAR2) RETURN int is
RETURNVAL int;
目前分類：PLSQL (11)
- Jul 06 Mon 2020 13:45
PL SQL 檢查統一編號
- Jun 29 Mon 2020 11:26
Oracle sequence number not allowed here
- Nov 22 Fri 2019 11:35
SQL 判斷區間是否重複
- Jul 17 Wed 2019 22:21
PL\SQL ELSE IF
- Jul 31 Tue 2018 08:56
PL/SQL decode
decode 語法 SELECT DECODE( 欲判斷的資料, 判斷值1, 相等的設定值1 , 判斷值2, 相等的設定值2 , ... , 不相等的設定值 ) FROM ...;
跟Case 一樣都是用來判斷使用
- Jul 19 Thu 2018 11:11
ORACLE UNION [ALL], INTERSECT, MINUS
- Jul 16 Mon 2018 14:58
Ora-01795 maximum number of expressions in a list is 1000
- Jun 04 Mon 2018 09:44
Oracle 查詢Table / column comment
--Table comment
select *
- May 24 Thu 2018 22:13
Oracle Database 11g Express Edition 安裝
1.Download Oracle Database 11g Expres
- May 24 Thu 2018 17:34
Oracle 查詢某Table 的Schema
- May 08 Tue 2018 14:17
PL/SQL Built-in Functions
Conversion Functions
|
Function Name
|
