Search for a command to run...
I just had someone call about this.
SELECT DBMS_XMLSCHEMA.generateschema('your_schema','your_type') FROM DUAL;
gives ORA-22303: type "your_schema"."your_type" not found
ora-21700
ora-06512
Just upper case your_schema and your_type -- YOUR_SCHEMA and YOUR_TYPE.
Hope this helps.
Finding matches in delimited strings and much more...
There are several great blog posts on this topic. In particular, this on from United Codes covers the details of each step. Marwa and I also did an APEX Instant Tip (episode 191) on this topic. This p
Interactive Reports, Interactive Grids, Charts...they all could benefit from faceted search.
I have written and done several APEX Instant Tips about the topics of using the declarative features of APEX (instead of writing code) and about using APEX REST Data Sources: APEX Instant Tips #180: Deploying APEX applications that include REST Data...
Check out APEX Instant Tips episode 178 for more information on this topic. Code instrumentation is key to developing maintainable and testable applications. The APEX_DEBUG PL/SQL API has everything I need and a lot of features under the covers that ...