Skip to content
June 3, 2023
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 Basic

PL/SQL Basic

Triggers

January 6, 2019April 17, 2020 - by OracleWorld

Database triggers are procedures that are fired/executed/triggered before or after data manipulation commands (DML). There are also “system triggers” that can be fired by other actions; such as logon, logoff, …

Triggers Read More
PL/SQL Basic

Bind Variables

October 11, 2018November 10, 2020 - by OracleWorld

Bind variables are an integral part of every application. There is no chance that any application will work correctly without them. It all about performance and understanding of Oracle’s architecture. …

Bind Variables Read More
PL/SQL Basic

Regular Expressions

October 10, 2018November 10, 2020 - by OracleWorld

This article will be pretty short because I don’t want to write about what are regular expressions capable of (foremost because I am not fond of them). There are many …

Regular Expressions Read More
PL/SQL Basic

Debugging

October 10, 2018April 17, 2020 - by OracleWorld

Even though there is no native debugger for PL/SQL you are still able to debug your code. PL/SQL, as well as any other procedural language, can fail on syntax/semantics checks …

Debugging Read More
PL/SQL Basic

Functions

October 8, 2018April 17, 2020 - by OracleWorld

Functions are very handy in order to customize your own computation logic. Unlike procedures, they return a value and therefore might be used in a SELECT statement. Functions are sometimes …

Functions Read More
PL/SQL Basic

Procedures

October 8, 2018September 18, 2019 - by OracleWorld

Oracle procedures are stored blocks of code that you can call anytime you want with or without parameters. It is especially handy when you need to call the same code …

Procedures Read More
PL/SQL Basic

Loops / Cursors

October 7, 2018February 5, 2019 - by OracleWorld

There are cases where you need to run a certain block multiple times. LOOPs are the answer. With them, you can define the logic when to exit the loop; whether …

Loops / Cursors Read More
PL/SQL Basic

Introduction to PL/SQL

October 4, 2018February 5, 2019 - by OracleWorld

With SQL queries you can easily extract or manipulate data in the database. But in order to make it sophisticated and implement some logic; SQL is simply not enough. This …

Introduction to PL/SQL 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

  • How To Read AWR Report
  • Multidimensional Arrays In Oracle PL/SQL
  • DBMS Scheduler – Chains
  • Chained Rows – Problems And How To Fix Them
  • SELECT Statement Processing

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 © 2023 Oracle World.