Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

WITH clause and Depth First Search

Posted on 27/01/202227/01/2022 by admin

In this article, I am going to explain how you can implement the depth first search with using the WITH clause or also known as subquery factoring clause. […]

More Details
Posted in SQLLeave a Comment on WITH clause and Depth First Search

How to reorder columns of table

Posted on 23/01/202227/01/2022 by admin

If you want to change the order of the columns of any table without recreating it, then the following trick will work for you. Suppose you want to […]

More Details
Posted in SQL3 Comments on How to reorder columns of table

How to make your PL/SQL code faster

Posted on 27/12/202108/06/2023 by admin

In this post, some important points of PL/SQL performance metrics has been explained. Oracle 19c has been used in all examples. Use Bind Variable Using bind variables can […]

More Details
Posted in PL/SQLLeave a Comment on How to make your PL/SQL code faster

PL/SQL Exception Handling in All Details

Posted on 15/12/202129/08/2022 by admin

Exception management is one of the most important part of all programming languages. Having a good understanding of this topic will help you a lot in debugging. In […]

More Details
Posted in PL/SQLLeave a Comment on PL/SQL Exception Handling in All Details

How to get OS environment variables in PL/SQL

Posted on 01/11/202101/11/2021 by admin

If you need to find out the value of any OS environment variable, such as ORACLE_HOME, without connecting your remote server. You can use DBMS_SYSTEM.GET_ENV procedure as shown […]

More Details
Posted in DBA, PL/SQLLeave a Comment on How to get OS environment variables in PL/SQL

5 Life Saving Features of Oracle

Posted on 16/06/202117/01/2023 by admin

1) Partitioned Outer Join I would like to start with PARTITIONED OUTER JOIN. Because it is one of the least used feature. Suppose that you have two basic […]

More Details
Posted in DBA, SQL1 Comment on 5 Life Saving Features of Oracle

SQL Plan Baselines

Posted on 23/05/202127/05/2021 by admin

SQL plan baseline is one of the most used tuning technique in Oracle database. Basically, with SQL plan baseline, you can change the execution plan of a sql […]

More Details
Posted in DBALeave a Comment on SQL Plan Baselines

How to find the SQL_ID of your SQL statement

Posted on 13/05/202127/06/2023 by admin

There are different ways to find the SQL_ID of an SQL statement. In this post, I am going to show two different ways of it. First, via dynamic […]

More Details
Posted in DBALeave a Comment on How to find the SQL_ID of your SQL statement

The easiest way to use Java in Oracle

Posted on 03/05/202108/05/2021 by admin

There are several methods to use Java in Oracle. I am going to show the easiest way. Basically, the Java interpreter starts running the application by calling main() […]

More Details
Posted in PL/SQL4 Comments on The easiest way to use Java in Oracle

How to run external scripts from DBMS_SCHEDULER

Posted on 18/04/202117/04/2022 by admin

In this post, I am going to explain how to run operating system level script files with using DBMS_SCHEDULER. All tests have been done in Oracle 19c. Generally, […]

More Details
Posted in DBALeave a Comment on How to run external scripts from DBMS_SCHEDULER

Posts navigation

Older posts
Newer posts

Recent Posts

  • How to use dynamic SQL with DBMS_SQL
  • ORA-01704 string literal too long
  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED

Recent Comments

  • admin on How to generate, parse and use JSON data
  • Johann on How to generate, parse and use JSON data
  • admin on How to reorder columns of table
  • Yogendra on How to reorder columns of table
  • ENOCK OLOO on Data encryption and decryption using PL/SQL

Categories

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

Flag Counter

© Copyright 2023, Çağlar Polat