Oracle Forms to Oracle APEX Migration (Help)

  Set the HTML Expression property on the RATING column to: < a href = "javascript:more('#DOCNO#,#DOCDT#');" > < span class = "fa u-hot-text report-star-rating" data-rating = "#RATING#" title = "Click For History" aria-hidden- "true" ></ span > < span class = "u-VisuallyHidden" > #RATING# </ span > </ a > Add this style sheet to the Custom CSS section of the Theme Roller: .report-star-rating { white-space : nowrap; } .report-star-rating [data-rating= "0" ] ::before { content : "\f006\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "1" ] ::before { content : "\f005\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "2" ] ::before { content : "\f005\f005\f006\f006\f006" ; } .report-star-rating [data-rating= "3" ] ::before { content : "\f005\f005...

what is Ajax call  and why Ajax  in Oracle APEX Ajax   stands for  Asynchronous JavaScript And XML .  In a nutshell, it is the use of the XMLHttpRequest object to communicate with servers. It can send and receive information in various formats, including JSON, XML, HTML, and text files. AJAX’s most appealing characteristic is its "asynchronous" nature, which means it can communicate with the server, exchange data, and update the page without having to refresh the page. The two major features of AJAX allow you to do the following: Make requests to the server without reloading the page Receive and work with data from the server. So basically, Ajax is a technique used to help you refresh (almost) any region in Apex without reloading the whole page which is so handy because imagine you have many regions on the page but you are only interested in getting the new data of a specific region after applying some filters. Furthermore, you can also get new Data based on use...

Thanks for  maxime_tremblay   Such nice  solution     Go to Page 0 ,  Page Load DA -- JavaScript  APEX 5 and 18 (function(ut, $) { var TREE_NAV_WIDGET_KEY = 'nav'; $(window).on('theme42ready', function() {     /* Make sure that the navigation menu is collapsed on page load */     if (ut.toggleWidgets.isExpanded(TREE_NAV_WIDGET_KEY)){         ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);     }     /* Expand on mouse over, collapse on mouse out */     $('.apex-side-nav.js-navCollapsed .t-Body-nav').hover(         function(){             ut.toggleWidgets.expandWidget(TREE_NAV_WIDGET_KEY);         },         function() {             ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);         }     ); }); })(apex.theme42, apex...

   JavaScript is a high-level, interpreted, dynamically-typed and client-side scripting language. HTML is used to create static web pages. JavaScript enables interactive web pages when used along with HTML and CSS. Document Object Manipulation (DOM) is a programming interface for HTML and XML documents. DOM acts as an interface between JavaScript and HTML combined with CSS. The DOM represents the document as nodes and objects i.e. the browser turns every HTML tag into a JavaScript object that we can manipulate. DOM is an object-oriented representation of the web page, that can be modified with a scripting language such as JavaScript. To manipulate objects inside the document we need to select it and then manipulate. Selecting an element can be done in five ways: document.querySelector() Method:  It returns the first element that matches the query. document.querySelectorAll() Method:  It returns all the elements that matches the query. document.getElementById() Method...

 (Oracle APEX 20.2  +ORDS 20.3 + Oracle 12c DB 12.2.0.1  + Tomcat 9.0) APEX 20.2 Desupported features include:      Desupported Web Listeners:              Legacy Web Listener – Oracle HTTP Server            Embedded PL/SQL Gateway      Desupported Browser:            Microsoft Internet Explorer 11 is desupported. a) Oracle APEX 20.2 Installations   1) Download the Oracle APEX 20.2  https://www.oracle.com/tools/downloads/apex-downloads.html 2) Unzip Folder in desired path            i.e  T:\App\Apex  3) Go to Apex Path  in command prompt and execute the SQLPLUS  Command          T:\app\apex> Sqlplus 4)  Please make sure you are connecting your desire container before start installation  CONN sys/Manager1/CISPDB AS SYSDBA ...

 A) IR Refresh Instead of Page Refresh when Model Dialog Close  https://apex.oracle.com/pls/apex/f?p=90922:18 1) Save function as refreshCurrent.js  function refreshCurrent(pRegionId){   var lReportId = "#"+pRegionId+"_ir";   /** @purpose retrieve the current min row of an IR by parsing the pagination label of an "X - Y" or X - Y of Z" scheme.     *@param IR id     */   function getCurrentPagination (pReportId) {     var currentText = apex.jQuery(".a-IRR-pagination-label", pReportId).text()       , currentMinRow = currentText.substring(0, currentText.indexOf("-")).trim();     return currentMinRow;   };      /** @purpose paginates the IR with the indicated settings      * @param pRegionId IR id     * @param pMinRow row to start the pagination at     * @param pMaxRows irrelevant. This is not parsed anywhere.      * @param pRowsFetched...

  HTTP to HTTPS (Tomcat) 1) Get the Secure Certificate first https://www.digicert.com/util/ https://support.code42.com/Administrator/6/Configuring/Install_a_CA-signed_SSL_certificate_for_HTTPS_console_access http://certificate.fyicenter.com/97_JDK_Keytool_How_to_Find_the_Java_Keytool_on_Windows.html https://support.code42.com/Administrator/6/Configuring/Install_a_CA-signed_SSL_certificate_for_HTTPS_console_access 2) Do the following step  keytool -genkey -alias APEX -keyalg RSA -keystore "C:\apex_way2cis_keystore.jks" -ext SAN=dns:apex.way2cis.com,ip:208.93.232.133 Keystore Password: Way2Cis@2020!! keytool -genkeypair -alias apex.way2cis.com -storetype jks -keystore apex.way2cis.com.jks -validity 366 -keyalg RSA -keysize 4096 keytool -certreq -alias apex.way2cis.com -file apex_way2cis.csr -keystore apex.way2cis.com.jks -ext san=dns:apex.way2cis.com keytool -importcert -alias apex.way2cis.com -file CAreply.p7b -keystore apex.way2cis.com.jks -trustcacerts keytool -importkeystor...

 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...

  A)     How to connect SQL Developer Tools with Oracle Autonomous Cloud DB   and how to Export Dump from local Db and import to Oracle Autonomous Cloud DB   Useful Link   https://blogs.oracle.com/apex/how-to-move-your-apex-applications-to-autonomous-database   https://blogs.perficient.com/2019/12/17/how-to-import-oracle-db-dumps-into-adw-using-sql-developer/   https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-import-data-from-object-store   1)     Connect Sql Developer with Oracle Autonomous Cloud DB   è Go to Oracle Cloud Infrastructure and login with your credential     Go to  Autonomous Transaction Processing     Click on Autonomous Database which you have created     Click on Service Console     go to Administration and Download the client Credential (Wallet) key             Enter the Password and click on dow...