Wednesday, June 4, 2025

Error From Interactive Grid - Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row locking.

›
Error: Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row ...
Wednesday, February 26, 2025

Search String Inside Oracle Database Objects SQL

›
SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;
Sunday, February 16, 2025

How to Implement Password Hide/Show in Login Page

›
Follow these steps to enable users to toggle between hiding and showing their password on the login page. Step 1: Add the Function and Glob...
Saturday, February 15, 2025

Automatic ORDS start / Create a windows service to open a software automatically

›
Step 1: Create the Batch File Open a text editor (like Notepad) and add the following code, replacing the path with your Oracle ORDS direct...
Thursday, February 13, 2025

Create List from Navigation Menu

›
 select null      c1_level,        ENTRY_TEXT     c2_name_for_label,        ENTRY_TARGET c3_target_url,        null      c4_is_current, ...
Saturday, January 25, 2025

Java to Oracle database Connection Using JDBC

›
Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...
Saturday, January 18, 2025

Confirmation Alert Before Submit / Conditional Button execution using one button JavaScript in Oracle Apex

›
Using below code you can take a confirmation before execution even you can do conditional button press and execution. apex.message.confirm( ...
Friday, January 17, 2025

Interactive Grid Alternating Row Color

›
1. Put the CSS into Page properties Inline->  .customAlternatingRow .a-IRR-table tr:nth-child(odd) td{background-color:#bac3cc} .customAl...
Tuesday, January 14, 2025

Audit Log Sample Trigger

›
 create or replace TRIGGER "SCHEMA"."UDS_CALL_LOG_INFO_BIU"      BEFORE INSERT OR UPDATE      ON "APEX_UDS"....
Monday, December 9, 2024

PDF to Text Covert by Oracle Apex

›
Here are the steps to convert and get the character into a region by Oracle Apex. Step1.  Create a page and Copy-Pest the below code into Pa...