Рет қаралды 1,731
#Combo_Box #APEX_23.2 #APEX #oracle_apex #Ali_saleh
My Course on udemy
www.udemy.com/...
www.udemy.com/...
www.udemy.com/...
----
my blogger
apex4help.blog...
---
CODE
declare
l_COURSES number;
begin
-- loop over any manually-entered tag descriptions
FOR C IN (
SELECT
COLUMN_VALUE
FROM
APEX_STRING.SPLIT(:P4_MANUAL_ENTRIES, ':')
) LOOP
-- append the new tag id to the delimited list
insert into COURSES(COURSES) values (C.column_value) returning id into l_COURSES;
:P4_COURSES := :P4_COURSES || CASE WHEN :P4_COURSES IS NOT NULL
THEN
':'
END || L_COURSES;
END
LOOP;
-- clear the manual entries item
:P4_MANUAL_ENTRIES := null;
end;
--
source
blogs.oracle.c...