today:
127
yesterday:
311
Total:
1,018,366
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
19 How-To Document / Change a Logo in a Page Template admin 2016.04.16 248
» If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 2018.05.19 244
17 eeeeee admin 2018.06.21 242
16 Process admin 2018.05.05 239
15 3D Pie Chart admin 2016.05.17 235
14 All Data DELETE from Table admin 2018.05.10 231
13 use a validation function for an element in apex 5.0 admin 2018.05.19 226
12 Apex setup procedure admin 2016.04.28 198
11 Captcha Test file admin 2016.04.18 192
10 CREATE TABLESPACE admin 2016.04.28 192
9 EXPORT & IMPORT admin 2016.05.01 191
8 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 179
7 wwv_flow_files admin 2016.05.01 168
6 BOOLEAN SAMPLE admin 2016.05.11 160
5 Oracle APEX 5.1.4 Installation admin 2018.04.17 154
4 Delimiter admin 2016.04.29 148
3 test admin 2016.05.11 143
2 Interactive Report admin 2016.05.07 138
1 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124