Skip to content
August 10, 2022
Oracle World :: Developer's Cheat Sheet

Oracle World

Developer's Guide

  • Home
  • SQL
    • SQL Basic
    • SQL Advanced
    • SQL Tips&Tricks
  • PL/SQL
    • PL/SQL Basic
    • PL/SQL Advanced
    • PL/SQL Tips&Tricks
  • DBA
    • DBA Basic
    • DBA Advanced
    • DBA Tips&Tricks
  • Architecture
  • Practice
  • Resources

PL/SQL Advanced

PL/SQL Advanced

PL/SQL Nested Blocks

January 6, 2021January 6, 2021 - by OracleWorld

Many developers are familiar with (or at least aware of) try-catch blocks in their codes. These help to isolate parts of codes inside the main program.  Oracle provides a similar …

PL/SQL Nested Blocks Read More
PL/SQL Advanced

Multidimensional Arrays In Oracle PL/SQL

April 3, 2020November 10, 2020 - by OracleWorld

Multidimensional arrays in Oracle PL/SQL can solve some tricky situations you cannot do with nested tables or it will be a bit complex. A multidimensional array is an array of …

Multidimensional Arrays In Oracle PL/SQL Read More
PL/SQL Advanced

Exceptions

February 25, 2019April 17, 2020 - by OracleWorld

Whenever you create a program block (no matter it is a trigger, procedure, package, …) you have to face errors, in Oracle PL/SQL they are called “exceptions”. We distinguish two …

Exceptions Read More
PL/SQL Advanced

SYS_CONTEXT

February 24, 2019April 17, 2020 - by OracleWorld

I dedicated to SYS_CONTEXT function one extra article even though there is nothing much to say 🙂 SYS_CONTEXT is a function used to retrieve information about Oracle environment. There are …

SYS_CONTEXT Read More
PL/SQL Advanced

What Is SQL Injection And How To Avoid It

January 27, 2019November 10, 2020 - by OracleWorld

SQL injection is a very serious topic and as a matter of fact, it is very easy to prevent. Though, it is overlooked so many times by all developers either …

What Is SQL Injection And How To Avoid It Read More
PL/SQL Advanced

Packages

October 4, 2018April 17, 2020 - by OracleWorld

A package is a schema object that can store variables, functions, procedures, constants, and other objects. The purpose of the package is to improve the modularity, performance, and security of data. The …

Packages Read More
PL/SQL Advanced

Collections and Records

October 4, 2018November 10, 2020 - by OracleWorld

PLSQL offers you an option how to store variables within an array; collections and records. They can hold values that can be treated as standalone values. Collections‘ elements must always …

Collections and Records Read More
PL/SQL Advanced

Logging

October 3, 2018February 5, 2019 - by OracleWorld

This post is not about LOGGING/NOLOGGING table option in Oracle which generates REDO Log entries or bypasses it eventually in case of NOLOGGING. This article is about custom logging feature in …

Logging Read More

Recent Posts

  • How To Cache Oracle Database
  • How To Trace Queries in Oracle with AUTOTRACE
  • PL/SQL Nested Blocks
  • How To Find Invalid Hints
  • Long Running Queries Monitoring

Most popular posts

  • Multidimensional Arrays In Oracle PL/SQL
  • DBMS Scheduler – Chains
  • How To Read AWR Report
  • Chained Rows – Problems And How To Fix Them
  • Logical Storage Structures

About Me

Hello, my name is Petr Hybler and I am an Oracle enthusiast and a professional Data whisperer. My journey started even before …

read more

Copyright © 2022 Oracle World.