Overview In Oracle APEX 23.2, the Image Upload Page Item revolutionizes image management. It offers a contemporary interface for users to preview and modify images before uploading, aligning with modern…
Read More1. Overview In this we are going to see about how to check the character in the numeric page item on lose focus and also going to check the decimal length on lose focus. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Java script` Ø Oracle Apex 22.1 3. Use Case There will be automatic validation for checking the number field but it will work only on clicking the button but we can also show the error on lose focus of the item when entering the characters in to it by using the below method.And also in this we are checking length of the decimal numbers in the lose focus. Architecture. Step 1: Create new page in oracle application and create a new region Step 2: Create a new page item as number field. Step 3: Create a dynamic action select javascript code and paste the following code. CODE : var a = $v(‘P3_NUMBER’); if(isNaN(a)) { apex.message.clearErrors(); if ( $(“#P3_NUMBER_error”).length == 0) { apex.message.showErrors([ { type: “error”, location: [ “page”, “inline” ], pageItem: “P3_NUMBER”, message: “Number Must be a Numeric.”, unsafe: false } ]) }…
Read More1. Overview In this we are going to update the details in the master table and the request will send to the request table we will show both forms in single screen with highlighted the changes in the request region and make the master region as read only. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Java script` Ø Oracle Apex 22.1 3. Use Case If we have a requirement for approval workflow. The data will maintain in master and request table.If we update the details in the master table and the request will be send through the request table.we will show both forms in single screen with highlighted the changes page item in the request region and make the master region as read only in approver screen . Architecture. Step 1: Create new page in oracle application with report and form Step 2: Create a new region as report make row id enabled and make it as primary key. Step 3: Create one request table for the master table. Create another region for request table,enable the row id and make it as primary key for the region. Step 4: In form page disable the start new row for request region. Step 5: Write a insert process for request table in update condition. Step 6: In page load make a dynamic action with server side condition where status flag is update. CODE: var a1 = $v(‘P3_EMPNO’); var b1 = $v(‘P3_EMPNO_1’); var a2 = $v(‘P3_ENAME’); var b2 = $v(‘P3_ENAME_1’); var a3 = $v(‘P3_JOB’); var b3 = $v(‘P3_JOB_1’); var a4 = $v(‘P3_HIREDATE’); var b4 = $v(‘P3_HIREDATE_1’); var a5 = $v(‘P3_SAL’); var b5 = $v(‘P3_SAL_1’); var a6 = $v(‘P3_COMM’);…
Read MoreDescription: SQL Server is the database management systems. If you want to protect your data and applications from hackers, malware, and other risks, you need to update and patch your…
Read MoreDescription: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. database tables that can store and retrieve any amount of data…
Read MoreQuery Store The Query Storeis a feature in SQL Server that helps you monitor query performance by capturing a history of queries, plans, and runtime statistics, etc. Benefits of using the Query…
Read MoreMigrating databases from Oracle to Azure SQL can unlock significant benefits, including cost savings, enhanced performance, and access to the full suite of Azure cloud capabilities. However, migration journeys can…
Read MoreThe security of data in Oracle Database is ensured through robust authentication, authorization, and auditing mechanisms. A critical aspect of data storage involves datafiles, which are essential components residing in…
Read MoreDatabase tables often contain sensitive information such as credit card details, contact information, and personal bank details, which require safeguarding against unauthorized access. To address this concern, Oracle 12c and…
Read MoreSQL server issue and solution Troubleshooting Tips for Seamless SQL Server Transactional Replication Introduction: Transactional Replication is a powerful High availability feature in SQL Server that allows the consistent and…
Read More