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 Tips&Tricks

PL/SQL Tips&Tricks

How To Tag a Particular Query

November 16, 2020November 17, 2020 - by OracleWorld

Sometimes it happens that you want to track and trace your query or block of code in the Shared SQL area (v$sql) or v$session. For this particular purpose, Oracle is …

How To Tag a Particular Query Read More
PL/SQL Tips&Tricks

Schema DDL Audit

May 21, 2020November 10, 2020 - by OracleWorld

Sometimes you might need to check who is messing up with your DB 🙂 You can either turn on the AUDIT TRAIL or, if you are crafty, you might wanna …

Schema DDL Audit Read More
PL/SQL Tips&Tricks

Parsing Results Of Dynamically Built SELECT Query

December 17, 2019November 10, 2020 - by OracleWorld

When you want (from whatever reason) parse data coming from dynamically built SELECT query you have to use EXECUTE IMMEDIATE and BULK COLLECT together with collections and records. See the …

Parsing Results Of Dynamically Built SELECT Query Read More
PL/SQL Tips&Tricks

Records As OUT Parameters

January 17, 2019November 10, 2020 - by OracleWorld

Sometimes it’s not only a single value we need to return but a whole set of data. In this case, it might be handy to return the data set as …

Records As OUT Parameters Read More
PL/SQL Tips&Tricks

Block Connection From Excel To Oracle

January 9, 2019November 10, 2020 - by OracleWorld

There might be several reasons why you want to block a connection to a database from excel files. It might not be only the Excel but other programs as well. …

Block Connection From Excel To Oracle Read More
PL/SQL Tips&Tricks

Logging Package

December 31, 2018November 10, 2020 - by OracleWorld

Being able to properly log all details about your processes is essential with regard to backtracking of issues or tuning the performance. With a proper log, you can easily see …

Logging Package 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.