Posts

Showing posts from July, 2020

Enabled SQL Developer Web (SDW) & ORDS Database API ORDS 19.4

SQL Developer Web (SDW)  ORDS 19.2 to 19.4 Migration /  Basic Setup to Enable ORDS Database API Bsic Information  Installing Oracle REST Data Services https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-673D35DD-9811-42F8-A500-4F494F79C470 https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-2C42D982-BF08-48E3-A4C6-3FE1A78287E3 Using Oracle® SQL Developer Web https://docs.oracle.com/en/database/oracle/sql-developer-web/19.2.1/sdweb/about-sdw.html#GUID-AF7601F9-7713-4ECC-8EC9-FB0296002C69 How to Configure / Run ORDS for SQL Developer Web and APEX in Standalone Mode: ORDS 19.4 + (Doc ID 2628004.1) GOAL This document is an overview on how to configure and run ORDS standalone for SQL Developer Web using the command line interface. It also includes the steps related to setting up APEX, since the ability to run APEX as well as SQL Develo...

how to convert double inverted commas to single inverted commas in Javascript

newTemp = mystring.replace(/"/g, "'"); or newTemp = mystring.replace(/"/g, '\'');

Hide Detail /Show Detail on Grid

1) Create Button HideDetail--> Action On Click -- JavaScrip Execute  var gridView = apex.region("emp").widget().interactiveGrid("getViews").grid; ["NOTES","ONLEAVE","HIREDATE","DEPTNO","RATING"].forEach(function(c) {     gridView.view$.grid("hideColumn", c); }); $("#showDetailsBtn").show(); // Static ID  $("#hideDetailsBtn").hide(); //Static ID 2) Create Button ShowDetail --> Action On Click -- JavaScript Execute var gridView = apex.region("emp").widget().interactiveGrid("getViews").grid; ["NOTES","ONLEAVE","HIREDATE","DEPTNO","RATING"].forEach(function(c) {     gridView.view$.grid("showColumn", c); }); $("#showDetailsBtn").hide();// Static ID  $("#hideDetailsBtn").show();// Static ID 

IG Tool Tips

       ==JavaScript Initialization Code of Attribute Property of GI =====        function(config) {                     config.defaultGridViewOptions =                      {                     rowHeader: "sequence",  //Sequence Number                    // reorderColumns: true,                     noStretch: true,                     persistSelection: true,                     //resizeColumns: false , //Not allowed Column resize                    // multiple: false, // Redio Box instead of Check Box             ...

Tab Label Font Color Change

Css Inline .t-Body .t-Tabs--simple .t-Tabs-link {     color: #0076df !important;  font-weight: bold;} s     

Model Dialog Runtime Resize / Round Corner / Title Color / Hide X on Dialog / hide Title Bar

Resize Model Dialog at run time Region --> Appearance --> CSS Classes js-dialog-size1200x600 Round Corner  Execute when Page Loads apex.util.getTopApex().jQuery(".ui-dialog").css({"border-radius": "8px 8px 8px 8px", "border-width": "1px"}); apex.util.getTopApex().jQuery(".ui-corner-all").css({"border-radius": "8px 8px 8px 8px", "border-width": "1px"}); apex.util.getTopApex().jQuery(".t-DialogRegion").css({"border-radius": "8px 8px 8px 8px", "border-width": "1px"}); OR $(".ui-dialog").css({"border-radius": "8px 8px", "border-width": "0px"}); $(".ui-corner-all").css({"border-radius": "8px 8px 8px 8px", "border-width": "0px"}); $(".t-DialogRegion").css({"border-radius": "8px 8px 8px 8px", "border-width...