Oracle Magazine, September/October 2018
Database Developer LOW CODE use a SQL postprocessing mechanism to reduce the number of columns displayed in the report 1 In the developer toolbar at the bottom of the page click the Edit Page 2 link 2 In the tree view on the left of Page Designer click Report 1 to select the report ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 80 region 3 In the properties on the right in the Local Post Processing section choose SQL Query for Type 4 In the SQL Query region overwrite the existing query with a copy and paste of the following query select ARTISTNAME TRACKNAME PREVIEWURL ARTWORKURL100 COLLECTIONPRICE RELEASEDATE COUNTRY CURRENCY from APEX SOURCE_ DATA 5 In the Appearance section of the properties on the right choose Blank with Attributes for Template This will simplify the region display and remove the unnecessary region title 6 In the tree view on the left of Page Designer under the report region expand the column list by clicking to the left of Columns ABOUT ORACLE APPLICATION EXPRESS Oracle Application Express Oracle APEX is a high productivity lowcode platform for creating modern responsive and accessible web applications A no cost feature of Oracle Database it is a compelling application development platform available in all Oracle Database Cloud services
You must have JavaScript enabled to view digital editions.