Reposted by Tobias Arnhold
Juhu,
wir haben diese Woche ein Frankfurt APEX Meetup!
Am 22.5. sind wir ab 17:30 bei Syntegris in Neu-Isenburg zu Gast.
Anmeldung über Meetup:
meetu.ps/e/P2Lvm/pMkw...
Wir freuen uns auf Euch!
@oracleace.bsky.social @ora2know.de
#orclAPEX
![Live SQL V2 script to show how delimited strings can be tokenized in the Oracle Database. My favorites are:
--
-- Alternative 1: Split with APEX_STRING.SPLIT
--
select record_id, count(column_value) as token_cnt
from tokens,
apex_string.split( record_tokens, ':')
group by record_id;
--
-- Alternative 2: Split with JSON_TABLE
--
select record_id, count(token) as token_cnt
from tokens,
json_table(
'["' || replace( replace( replace( record_tokens, '\', '\\' ), '"', '\"' ), ':', '","' ) || '"]',
'$[*]'
columns (token varchar2(255) path '$' ))
group by record_id;](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:tjdsxvfthkvpeyggc4p4rjjg/bafkreickmle6febbpcuwuhzmed5vo426g7lrtcasbypsncglxlkjsp6y5u)
