today:
166
yesterday:
26,029
Total:
577,707

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

admin 2018.05.19 20:25 Views : 14

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