Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: APEX

Unlock Apex admin account

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

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 admin

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 admin

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 admin

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 admin

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

  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections
  • How to use PL/SQL functions within SQL
  • The power of MATCH_RECOGNIZE

Recent Comments

  • ENOCK OLOO on Data encryption and decryption using PL/SQL
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn
  • Anonymous on Unlock Apex admin account
  • Anonymous on How to reorder columns of table

Archives

  • January 2023
  • October 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery
© Copyright 2023, Çağlar Polat