Caglar's Oracle Blog

Caglar's Oracle Blog

About SQL, PL/SQL and Oracle APEX

  • About Me

Category: APEX

How to implement wait spinner in APEX dynamic action

Posted on 08/04/202415/04/2024 by Caglar

So, the easiest way to implement showing a spinner in a dynamic action is as follows. Let’s implement it in Apex. I created a button called btnRun and […]

More Details
Posted in APEX4 Comments on How to implement wait spinner in APEX dynamic action

Unlock Apex admin account

Posted on 18/02/202017/01/2021 by Caglar

You can find the lock accounts from the following query. So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block. You […]

More Details
Posted in APEX1 Comment on Unlock Apex admin account

Print clob data with htp.prn

Posted on 04/02/202004/02/2020 by Caglar

As it is known, HTP.PRN procedure does not support clob data. None of the HTP.PRN procedures shown in below support CLOB data type as input. So, the following […]

More Details
Posted in APEX3 Comments on Print clob data with htp.prn

Trigger parent page when modal closed

Posted on 20/05/201921/05/2019 by Caglar

In order to trigger parent page, in Apex 5.0, when user close the modal without to click any button. First, you will need to define the following Javascript […]

More Details
Posted in APEXLeave a Comment on Trigger parent page when modal closed

How to make pritable page in APEX

Posted on 21/03/201921/03/2019 by Caglar

It can be done with Javascript. The following Javascript code, make the intended part of page as printable. You can create a dynamic action for this.

More Details
Posted in APEXLeave a Comment on How to make pritable page in APEX

Trigger dialog close event in Apex

Posted on 04/03/201904/03/2019 by Caglar

In order to trigger dialog close event in APEX 5. You can write the following javascript code in the function and global declaration part of parent page. It […]

More Details
Posted in APEX1 Comment on Trigger dialog close event in Apex

Recent Posts

  • How to use LONG column in the WHERE clause
  • How to use XMLTABLE
  • How to implement wait spinner in APEX dynamic action
  • How to list all privileges of a user
  • How to create or alter a job

Recent Comments

  • Alexandre on How to implement wait spinner in APEX dynamic action
  • Maurits Groenenberg on How to view alert log file
  • Caglar on FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • Anjali Damani on FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • Caglar on How to implement wait spinner in APEX dynamic action

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery

Flag Counter

© Copyright 2025, Çağlar Polat