Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

How to use Flashback

Posted on 10/01/202110/01/2021 by admin

Flashback feature is available only for enterprise edition. In this article, Oracle 19c has been used for all examples. With flashback feature you can recover your table or […]

More Details
Posted in DBALeave a Comment on How to use Flashback

How to open pluggable database automatically

Posted on 02/01/202102/01/2021 by admin

There are different startup phases of Oracle database. In multitenant architecture, startup and shutdown commands of container database are same as the regular database. After opening the container […]

More Details
Posted in PL/SQLLeave a Comment on How to open pluggable database automatically

How to create a temporary job

Posted on 26/12/202026/12/2020 by admin

Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]

More Details
Posted in DBA, PL/SQLLeave a Comment on How to create a temporary job

How to use Data Pump between different Oracle versions

Posted on 04/12/202004/12/2020 by admin

According to the documentations, if the target database is higher than the source database, the VERSION parameter does not have to be specified. There is an exception, if […]

More Details
Posted in DBALeave a Comment on How to use Data Pump between different Oracle versions

How to export / import schema with Data Pump

Posted on 23/11/202004/12/2020 by admin

There are several export/import modes. These are listed in the following section. Full Mode Schema Mode Table Mode Tablespace Mode Transportable Tablespace Mode In this article I will discuss about schema mode export […]

More Details
Posted in DBALeave a Comment on How to export / import schema with Data Pump

ORA-30926 unable to get a stable set of rows in the source tables

Posted on 23/11/202023/11/2020 by admin

In this post, I am going to talk about ORA-30926 error and how to solve it. Let’s create the following tables for our example. This error occurs due […]

More Details
Posted in SQLLeave a Comment on ORA-30926 unable to get a stable set of rows in the source tables

How to split comma separated string into rows

Posted on 26/05/202026/05/2020 by admin

In rare cases we might need to convert string data into rows. So, you can simply do this using the code below. If your string is not comma […]

More Details
Posted in SQLLeave a Comment on How to split comma separated string into rows

Adaptive Cursor Sharing & Histograms

Posted on 24/05/202025/05/2020 by admin

Adaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]

More Details
Posted in DBA, SQLLeave a Comment on Adaptive Cursor Sharing & Histograms

Analytic functions & Windowing clause

Posted on 09/05/202015/09/2020 by admin

Analytic functions have been used from the early versions of Oracle. It make it easy to developers in many tasks, especially reporting. In this article, I am going […]

More Details
Posted in SQLLeave a Comment on Analytic functions & Windowing clause

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 APEXLeave a Comment on Unlock Apex admin account

Posts navigation

Older posts

Recent Posts

  • How to use Flashback
  • How to open pluggable database automatically
  • How to create a temporary job
  • How to use Data Pump between different Oracle versions
  • How to export / import schema with Data Pump

Recent Comments

  • ismail kılıç on How to change database log mode to archiving mode
  • Mark on Trigger dialog close event in Apex

Archives

  • 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
  • XQuery
© Copyright 2021, Çağlar Polat