Posts Tagged ‘oracle’

Oracle DBMS_SCHEDULER Part 2 – The API

Read the rest!

Read the rest of this entry »

Oracle DBMS_SCHEDULER Part 1–The Basics

Read the rest! Read the rest of this entry »

Parallel Operations in Oracle 11g

Read the rest! Read the rest of this entry »

We’ve had problems with that!

Read the rest! Read the rest of this entry »

Stupid Proc Tricks -The Weird and Wonderful Overload

When overloading a procedure or function it is the calling parameters that make the difference. The return type does not make a difference as far as the ability to overload. Generally, when talking about overloaded procedures, you will hear or read something like “You must change at least one of the parameter data types to overload it.” But that’s not really true.

Click to continue reading “Stupid Proc Tricks -The Weird and Wonderful Overload”… Read the rest!

Read the rest of this entry »

Designing the Data Mart – Part 1

Read the rest! Read the rest of this entry »

PL/JSON v0.6.2 Released

Read the rest! Read the rest of this entry »

Oracle INFORMATION_SCHEMA

Read the rest! Read the rest of this entry »

PL/JSON v0.6 Released to SourceForge

Read the rest! Read the rest of this entry »

Use a Pipelined Function to Select Source Code Arguments

Read the rest!

Read the rest of this entry »

Stupid Database Tricks – Shutdown the server from a stored procedure

Read the rest! Read the rest of this entry »

ORA_Tweet Now Does Short URLs

Read the rest! Read the rest of this entry »

Private vs Public Global Variables

Read the rest! Read the rest of this entry »

JSON In (and out) of Oracle – JSON Data Type

Read the rest! Read the rest of this entry »

Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API

Read the rest! Read the rest of this entry »

Oracle Data Types – 5 FAQs About Number

Read the rest! Read the rest of this entry »

Advanced Queues and Streams: A Definition in Plain English

Read the rest! Read the rest of this entry »

My Introduction

Read the rest! Read the rest of this entry »

When WHEN OTHERS is Evil

Read the rest! Read the rest of this entry »

uCertify Oracle Certification Software Review

Read the rest! Read the rest of this entry »

Building a PL/SQL Code Parser (using PL/SQL), Part 3

Read the rest! Read the rest of this entry »

Building a PL/SQL Code Parser (using PL/SQL), Part 2

Read the rest! Read the rest of this entry »

Group By Grouping Sets

Read the rest! Read the rest of this entry »

Building a PL/SQL Code Parser (using PL/SQL), Part 1

Read the rest! Read the rest of this entry »

PL/XML – XML Based Scripting for PL/SQL

Read the rest! Read the rest of this entry »

XML in the Database: A Brief Overview

Read the rest! Read the rest of this entry »

Oracle Objects, Types and Collections: Part 1

Read the rest! Read the rest of this entry »

TOTD, What is a DBA?

Read the rest! Read the rest of this entry »

Oracle Security: A Definition in Plain English, Part 2

Read the rest! Read the rest of this entry »

Oracle PowerBrowser

Read the rest! Read the rest of this entry »