Hi! I am trying to trim spaces in the IG column - Popup LOV search, for instance, when I copy and paste text with space before the first letter I can't get results, without space it works. How to trim spaces in the search box? Thanks in advance!
Discy Latest Questions
I am trying to display XMLTYPE in Oracle APEX. Query: select id, xmlquery('declare default element namespace "http://www.omg.org/spec/BPMN/20100524/MODEL"; count(//definitions/process/task)' passing xmltype(diagram) returning content) as tasks process_table The Diagram column is clob. Oracle APEX return [SYS.XMLTYPE] in the report for this column, but APEX SQL Commands return values correctly. How to display the value in the report?