You could do a count(*)
instead
declare
l_cnt integer;
begin
select count(*)
into l_cnt
from items
where id_referencia = :P2_REFERENCIA;
if( l_cnt >= 1 )
then
return true;
else
return false;
end if;
end;
If you really wanted to do an exists
, you'd do something like this. I don't know why you'd want to do this assuming that id_referencia
is the primary key of the table. But you could
declare
l_exists integer;
begin
begin
select 1
into l_exists
from dual
where exists( select 1
from items
where id_referencia = :P2_REFERENCIA );
exception
when no_data_found
then
l_exists := 0;
end;
if( l_exists = 1 )
then
return true;
else
return false;
end if;
end;
No. | Subject | Author | Date | Views |
---|---|---|---|---|
66 | NVL | admin | 2016.05.19 | 175 |
65 | INSERT PROCESS | admin | 2016.04.28 | 176 |
64 | TAP ( Main & Sub ) / Button 의 Switch | admin | 2016.04.28 | 179 |
63 | DELETE PROCESS | admin | 2016.04.28 | 180 |
62 | Delete Message - Are you sure you want to delete this object? | admin | 2016.04.28 | 181 |
61 | JAVA for delete | admin | 2016.04.28 | 181 |
60 | CREATING A TABLE / SEQUENCE / TRIGGER | admin | 2016.04.28 | 186 |
59 | UPDATE PROCESS | admin | 2016.04.28 | 188 |
58 | EXPORT & IMPORT | admin | 2016.05.01 | 191 |
57 |
Captcha Test
![]() | admin | 2016.04.18 | 192 |
56 | CREATE TABLESPACE | admin | 2016.04.28 | 192 |
55 | Using SQL*Plus to Unlock and Change Passwords | admin | 2023.06.04 | 195 |
54 | Apex setup procedure | admin | 2016.04.28 | 198 |
53 | TABLE PRINT | admin | 2018.06.18 | 210 |
52 | Name Show | admin | 2016.04.28 | 217 |
51 | How to convert DATE to NUMBER | admin | 2018.05.27 | 217 |
50 | MISSIONARY_SUB | admin | 2018.06.25 | 223 |
49 | IF/ELSE ... CASE WHEN | admin | 2018.06.25 | 223 |
» | use a validation function for an element in apex 5.0 | admin | 2018.05.19 | 226 |
47 | All Data DELETE from Table | admin | 2018.05.10 | 231 |