Hi.
First of all, please know that I am not good at English.
I want to use Oracle Apex to scan the QR code and save information about it.
I let the information in the QR code enter automatically in the text box. However, since there are many information integrated, I would like to use the separator ":" to decompose the information and store the information in a table.
I'm trying to do this with Apex's dynamic action, but I'm not sure about SQL.
Vinish Kapoor
You can use apex_string.split() function to get the values separated by a colon. Below is an example of SQL query:
Output
Replace 'AB:XY:ZZ' with your page item in SQL query as below: