Archive for the ‘Learn Oracle’ Category

Using Bind Variables

Read the rest of this entry »

Oracle DBMS_SCHEDULER Part 2 – The API

Read the rest of this entry »

OCFS – Oracle Cloud File System

Read the rest of this entry »

Oracle DBMS_SCHEDULER Part 1–The Basics

Read the rest of this entry »

Designing the Data Mart – Part 2

Read the rest of this entry »

Designing the Data Mart – Part 1

Read the rest of this entry »

PL/JSON v0.6.2 Released

Read the rest of this entry »

PL/JSON v0.6 Released to SourceForge

Read the rest of this entry »

Use a Pipelined Function to Select Source Code Arguments

Read the rest of this entry »

Stupid Database Tricks – Shutdown the server from a stored procedure

Read the rest of this entry »

ORA_Tweet Now Does Short URLs

Read the rest of this entry »

Calculating Business Days and Business Days Between

Read the rest of this entry »

Private vs Public Global Variables

Read the rest of this entry »

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

Read the rest of this entry »

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

Read the rest of this entry »

Oracle Data Types – 5 FAQs About Number

Read the rest of this entry »

Advanced Queues and Streams: A Definition in Plain English

Read the rest of this entry »

Oracle Advanced Replication: A Definition in Plain English

Read the rest of this entry »

uCertify Oracle Certification Software Review

Read the rest of this entry »

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

LewisC’s An Expert’s Guide to Oracle Technology
Is it possible to build a PL/SQL parser using nothing but PL/SQL? To answer that question, I guess I need to define “PL/SQL parser”. What would be the intention of this parser?
I would like a way to pa…

Click to continue reading “Building a PL/SQL Code Parser (using PL/SQL), Part 1″

Read the rest of this entry »

Comment by LewisC on 10 Tips For Complete Database Newbies

Thank you. Comments like that are exactly why I do this.

LewisC

!***! Entry Link: 10 Tips For Complete Database Newbies!***!

Click to continue reading “Comment by LewisC on 10 Tips For Complete Database Newbies”

Read the rest of this entry »

Comment by Kalai Selvi on 10 Tips For Complete Database Newbies

Wow. I’ve been toying around the idea of learning Oracle. Have read few manuals and tried my hands on 9i. But then later I moved on to .Net and now I’m back to Oracle and am looking to improve my hands on 10g. And after going thtrough your blog, it’s kinda motivating and guiding. Nice posts. Thanks a lot Lewis.

!***! Entry Link: <a href=”http://it.toolbox.com/blogs/oracle-guide/10-tips-for-complete-database-newbies-24

Click to continue reading “Comment by Kalai Selvi on 10 Tips For Complete Database Newbies”

Read the rest of this entry »

PL/SQL String Helper Package

LewisC’s An Expert’s Guide to Oracle Technology
I needed to update some files and that meant updating some utility functions that I haven’t looked at in a long time. I decided to share a few of them today.
One of the most important aspects of PL/SQL…

Click to continue reading “PL/SQL String Helper Package”

Read the rest of this entry »

PL/XML – XML Based Scripting for PL/SQL

Read the rest of this entry »

XML in the Database: A Brief Overview

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 3

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 2

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 1

Read the rest of this entry »

How to interview an Oracle Developer

Read the rest of this entry »

Oracle Security: A Definition in Plain English, Part 3

Read the rest of this entry »