today:
74,668
yesterday:
194,039
Total:
2,794,339

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

admin 2018.05.19 20:25 Views : 87

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 79 2025.11.23
31 ATACCESS admin 77 2024.03.02
30 꿈 - 08/26/2018 admin 134 2018.08.26
29 Medwigs admin 134 2018.07.17
28 TABLE PRINT admin 126 2018.06.18
27 FOOTER admin 139 2018.06.16
26 SQL CODE (1) admin 119 2018.06.16
25 GP PRINT admin 77 2018.05.31
24 How to convert DATE to NUMBER admin 79 2018.05.27
23 DATE Compare admin 82 2018.05.22
» If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 87 2018.05.19
21 use a validation function for an element in apex 5.0 admin 74 2018.05.19
20 Validation to detect text in numeric field admin 81 2018.05.19
19 All Data DELETE from Table admin 81 2018.05.10
18 Process admin 83 2018.05.05
17 소식 궁금 합니다. 감사또감사 127 2018.05.21
16 HTTP ERROR 500 admin 339 2018.05.14
15 05/10/2018 - SET UP admin 143 2018.05.10
14 05/04/2018 admin 123 2018.05.04
13 05/04/2018 admin 129 2018.05.04
Write Tag