today:
144
yesterday:
242
Total:
1,004,302
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;
No. Subject Author Date Views
126 ACTION admin 2019.01.11 6456
125 Fundamentals of PL/SQL admin 2016.05.10 2038
124 QR Code plugin admin 2017.11.30 1587
123 QR Code plugin Process admin 2017.11.30 964
122 How to Update Oracle XE Version admin 2018.02.23 930
121 GP PRINT admin 2018.05.31 918
120 INSTR admin 2016.05.19 789
119 SELECT last_name FROM admin 2018.12.12 742
118 TREE admin 2016.05.18 722
117 IMP admin 2018.10.08 719
116 JK admin 2019.02.05 702
115 CREATE TABLE admin 2018.09.25 471
114 APEX Password Change admin 2016.08.26 461
113 Membership Management admin 2016.06.09 435
112 JavaScript for Member List admin 2016.08.17 432
111 QRCODE admin 2020.05.25 405
110 control break admin 2016.06.25 398
109 SQL admin 2016.07.15 396
108 DATE Compare admin 2018.05.22 366
107 APEX Web Services Proxy Settings admin 2016.06.07 359