Skip to main content

Home/ Groups/ BI-TAGS
cezarovidiu

Oracle APEX Interactive report based on PLSQL function | Oracle Application Express - 0 views

  • Unfortunately Oracle have failed to allow the report to be based on a PLSQL function returning the query.
  • Step1.Create a collection based on a query. The code for this should be placed in a before header process APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY(p_collection_name => ‘IR_TEST’,p_query => function_returning_query );
  • Step 2.Create an interactive report querying a collection. Select *From apex_collectionsWhere collection_name = ‘IR_TEST’;
cezarovidiu

Understanding the Oracle REST Data Services Configuration Folder | cdivilly - 0 views

  • java -jar ords.war configdir /tmp/wls/conf
  • Configure ORDS by doing: 1java -jar apex.war
  •  
    "java -jar apex.war"
« First ‹ Previous 281 - 300 of 767 Next › Last »
Showing 20 items per page