today:
1,838
yesterday:
3,564
Total:
1,619,316

If you want to use EXISTS in a PL/SQL function returning BOOLEAN

admin 2018.05.19 20:25 Views : 59

If you want to use EXISTS in a PL/SQL function returning BOOLEAN,try this
DECLARE
  v_exist NUMBER;
BEGIN

SELECT 1 
INTO v_exist
FROM DUAL WHERE EXISTS (select id_referencia 
                                 from items
                                 where id_referencia = :P2_REFERENCIA)

  IF v_exist IS NOT NULL
  THEN
    RETURN true;
  ELSE
    RETURN false;
  END IF;
END;
I want to
List
No. Subject Author Views Date
32 PHOTO SIZE 줄이기 admin 56 2025.11.23
31 ATACCESS admin 54 2024.03.02
30 꿈 - 08/26/2018 admin 88 2018.08.26
29 Medwigs admin 84 2018.07.17
28 TABLE PRINT admin 82 2018.06.18
27 FOOTER admin 83 2018.06.16
26 SQL CODE (1) admin 72 2018.06.16
25 GP PRINT admin 45 2018.05.31
24 How to convert DATE to NUMBER admin 52 2018.05.27
23 DATE Compare admin 52 2018.05.22
» If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 59 2018.05.19
21 use a validation function for an element in apex 5.0 admin 50 2018.05.19
20 Validation to detect text in numeric field admin 50 2018.05.19
19 All Data DELETE from Table admin 54 2018.05.10
18 Process admin 52 2018.05.05
17 소식 궁금 합니다. 감사또감사 89 2018.05.21
16 HTTP ERROR 500 admin 170 2018.05.14
15 05/10/2018 - SET UP admin 89 2018.05.10
14 05/04/2018 admin 81 2018.05.04
13 05/04/2018 admin 85 2018.05.04
Write Tag