Archive for the ‘Learn Oracle’ Category

Using Bind Variables

Posted in November 3, 2011 ¬ 3:19 pmh.LewiComments Off
Read the rest of this entry »
development, Learn Oracle, oracle

Oracle DBMS_SCHEDULER Part 2 – The API

Posted in February 14, 2011 ¬ 12:32 pmh.Lewi1 Comment »
Read the rest of this entry »
Learn Oracle, pl/sql, Solve Problems, Stay Current, ,

OCFS – Oracle Cloud File System

Posted in February 12, 2011 ¬ 12:19 pmh.Lewi1 Comment »
Read the rest of this entry »
cloud computing, cloud database, Executive Overview, Learn Oracle, Stay Current

Oracle DBMS_SCHEDULER Part 1–The Basics

Posted in January 30, 2011 ¬ 11:47 amh.Lewi1 Comment »
Read the rest of this entry »
Learn Oracle, Solve Problems, Stay Current, , , ,

Designing the Data Mart – Part 2

Posted in May 18, 2009 ¬ 10:21 amh.Lewi2 Comments »

Read the rest of this entry »
data warehouse, database, Learn, Learn Oracle, Solve Problems, , , , ,

Designing the Data Mart – Part 1

Posted in May 16, 2009 ¬ 10:35 amh.Lewi1 Comment »
Read the rest of this entry »
Architect, data model, data warehouse, Learn Oracle, Solve Problems, , , , ,

PL/JSON v0.6.2 Released

Posted in May 9, 2009 ¬ 8:58 amh.Lewi1 Comment »
Read the rest of this entry »
data types, database, development, Learn Oracle, open source, oracle, pl/sql, Solve Problems, , , , ,

PL/JSON v0.6 Released to SourceForge

Posted in April 27, 2009 ¬ 7:21 amh.Lewi3 Comments »
Read the rest of this entry »
Data, data model, data types, database, development, language, Learn Oracle, open source, pl/sql, programming, , , , ,

Use a Pipelined Function to Select Source Code Arguments

Posted in April 23, 2009 ¬ 6:01 pmh.LewiComments Off
Read the rest of this entry »
database, development, Learn Oracle, pl/sql, programming, Solve Problems, , , , , ,

Stupid Database Tricks – Shutdown the server from a stored procedure

Posted in April 19, 2009 ¬ 3:38 pmh.LewiComments Off
Read the rest of this entry »
database, development, Learn Oracle, pl/sql, programming, Solve Problems, ,

ORA_Tweet Now Does Short URLs

Posted in April 11, 2009 ¬ 8:57 amh.LewiComments Off
Read the rest of this entry »
Blogging, development, Learn Oracle, open source, Opinion, pl/sql, , , ,

Calculating Business Days and Business Days Between

Posted in April 6, 2009 ¬ 3:13 pmh.LewiComments Off
Read the rest of this entry »
data warehouse, development, Learn, Learn Oracle, oracle, pl/sql, Solve Problems, SQL, , , , , ,

Private vs Public Global Variables

Posted in April 1, 2009 ¬ 11:47 amh.Lewi1 Comment »
Read the rest of this entry »
Blogging, development, Learn Oracle, Opinion, oracle, pl/sql, programming, , ,

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

Posted in March 25, 2009 ¬ 6:04 amh.Lewi14 Comments »
Read the rest of this entry »
data types, development, Learn Oracle, open source, oracle, pl/sql, Solve Problems, , , , ,

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

Posted in March 15, 2009 ¬ 11:01 amh.Lewi23 Comments »
Read the rest of this entry »
development, Learn Oracle, open source, oracle, pl/sql, Solve Problems, , , , ,

Oracle Data Types – 5 FAQs About Number

Posted in March 13, 2009 ¬ 10:25 amh.Lewi6 Comments »
Read the rest of this entry »
compatibility, data types, database, Learn Oracle, oracle, Solve Problems, tutorial, , , , , , ,

Advanced Queues and Streams: A Definition in Plain English

Posted in March 8, 2009 ¬ 9:11 pmh.LewiComments Off
Read the rest of this entry »
Definition, glossary, Learn Oracle, oracle, Solve Problems, , , , , , , , , , ,

Oracle Advanced Replication: A Definition in Plain English

Posted in March 8, 2009 ¬ 9:05 pmh.Lewi2 Comments »
Read the rest of this entry »
Definition, Learn, Learn Oracle, Solve Problems, , , , , , , , , , ,

uCertify Oracle Certification Software Review

Posted in February 17, 2009 ¬ 10:16 pmh.Lewi6 Comments »
Read the rest of this entry »
Learn, Learn Oracle, oracle, SQL, , ,

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

Posted in February 1, 2009 ¬ 7:58 pmh.An Expert's Guide to Oracle TechnologyComments Off

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 »
Learn Oracle, SQL

Comment by LewisC on 10 Tips For Complete Database Newbies

Posted in January 16, 2009 ¬ 7:19 amh.Comments for An Expert's Guide to Oracle TechnologyComments Off

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 »
Learn, Learn Oracle, oracle

Comment by Kalai Selvi on 10 Tips For Complete Database Newbies

Posted in January 15, 2009 ¬ 7:53 pmh.Comments for An Expert's Guide to Oracle TechnologyComments Off

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 »
Learn, Learn Oracle, oracle

PL/SQL String Helper Package

Posted in December 8, 2008 ¬ 2:49 pmh.An Expert's Guide to Oracle TechnologyComments Off

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 »
Learn Oracle, SQL

PL/XML – XML Based Scripting for PL/SQL

Posted in September 12, 2006 ¬ 7:30 pmh.LewiComments Off
Read the rest of this entry »
development, Learn Oracle, open source, oracle, pl/sql, programming, Solve Problems, , , , ,

XML in the Database: A Brief Overview

Posted in June 2, 2005 ¬ 5:46 amh.LewiComments Off
Read the rest of this entry »
data types, development, Learn Oracle, Opinion, oracle, pl/sql, relational database, Solve Problems, Stay Current, , , , , , , , ,

Oracle Objects, Types and Collections: Part 3

Posted in May 26, 2005 ¬ 6:11 amh.LewiComments Off
Read the rest of this entry »
data types, database, development, language, Learn Oracle, pl/sql, Solve Problems, , , , , , , , , , , , , , , , ,

Oracle Objects, Types and Collections: Part 2

Posted in May 14, 2005 ¬ 11:30 amh.LewiComments Off
Read the rest of this entry »
data types, database, language, Learn Oracle, pl/sql, Solve Problems, , , , , , , , , , , , , , , , , , , , , , , , ,

Oracle Objects, Types and Collections: Part 1

Posted in May 5, 2005 ¬ 2:49 pmh.Lewi1 Comment »
Read the rest of this entry »
data types, database, Definition, language, Learn Oracle, oracle, pl/sql, Solve Problems, , , , , , , , , , , , , ,

How to interview an Oracle Developer

Posted in May 3, 2005 ¬ 7:51 amh.LewiComments Off
Read the rest of this entry »
Find Jobs, interview, Learn Oracle, Opinion, programming, , , , , , , , , , , ,

Oracle Security: A Definition in Plain English, Part 3

Posted in April 17, 2005 ¬ 5:58 amh.LewiComments Off
Read the rest of this entry »
career, database, Learn Oracle, Opinion, Solve Problems, , , , , , , , , , ,
 

Array