Home | Tip of the Week | Tip of the Week Archive | Partners | Clients | History | Friends

Tip of the Week Archive

Tip Topics (click the topic name to go to that topic): Consultant's Toolkit, Database Management, Database Design & Development, PL/SQL, SQL, UNIX / Linux, Windows, Other Stuff

All tips from the first year are available in our ebook Oracle Tips from the Real World...52 Weeks with Alydan Consulting and are marked below as being in (pdf) format. Clicking on those tips will take you to the ebook.

Last Week's Tip

• Passing a Status Code from SQL*Plus to a Unix Shell Script

Consultant's Toolkit (return to top of page)

• Editor Wars...ConTEXT vs PFE vs Notepad / WordPad

• Quest Data Dictionary for Oracle

• Email Enable Your Windows Applications with Blat

• Having It Your Way! Customizing Your SQL*Plus Environment (pdf)

• MetaLink Magic...Help with ORA-600 and ORA-7445 Errors (pdf)

• Once Upon a Time, There Was an OTN Toolbar (pdf)

• Programmer's File Editor...An Essential Part of My Consulting Toolkit (pdf)

Database Management (return to top of page)

• Adventures with Backup and Recovery II...The Hot Backup

• Adventures with Backup and Recovery I...Archivelog Mode

• spfile or pfile...Inquiring Minds Want to Know

• Three Easy Steps to Database Connection Auditing

• Adventures with Export/Import...Oracle 9.2.0.7

• Archivelog Mode...The Cure for Those Sleepless Nights

• Data Files...A Moving Experience

• Problems with Permissions and Passwords II

• Problems with Permissions and Passwords

• Advice on Improving Your Database's Memory II

• Advice on Improving Your Database's Memory

• Access to Oracle Table Migration Using ERwin and ODBC (Part I) (pdf)

• Access to Oracle Table Migration Using ERwin and ODBC (Part II) (pdf)

• Controlfiles...Make Them Part of Your Datafile Relocation Program (pdf)

• The PGA_AGGREGATE_TARGET or Memory Management Made Easy(ier) (pdf)

• spfile to pfile and Back Again (pdf)

• spfile to pfile and Back Again II - Parameter Changes...If You Have to Restart the Database Anyway... (pdf)

• SQL*Plus Autotrace (pdf)

• Stop the Needless Proliferation of tnsnames.ora Files! (pdf)

• Those Oracle Disk Devouring Log Files... (pdf)

Database Design & Development (return to top of page)

• Perception is Reality? Improving Performance with DBMS_JOB

• Data Access and Loading Using External Tables

• DBMS_OUTPUT, Vanishing Spaces, and When is a Million not a Million (pdf)

• A New and Improved DBMS_OUTPUT (pdf)

• Are Your Sequences Out of Control? Resetting Sequences (pdf)

• Boost Your Database Performance and Improve Your Query Accuracy with Function Based Indexes! (pdf)

• Getting Insert and Update Counts from the Merge Statement (pdf)

• Improve VB.NET Oracle Performance with ODP.NET Array Binding (pdf)

• Optimize Performance with the Right Optimizer. Let the Logon Trigger Decide (pdf)

• Separate Schemas for Tables and Triggers? Why Not? (pdf)

• Who Did This to My Data and When? Timestamping and Userstamping* with Triggers (pdf)

PL/SQL (return to top of page)

• Parsing a CSV File Using PL/SQL (Revisited)

• The 500 Column Question

• The 75,000,000 Row Question

• A PL/SQL Routine to Determine a UPC's Check Digit (pdf)

• Parsing a Delimited File Using PL/SQL (pdf)

• Parsing a csv File Using PL/SQL (pdf)

• Parsing a csv File Using PL/SQL (Part 2) (pdf)

• Sorting Using Associative Arrays (pdf)

• Using PL/SQL to Create Output for Excel from a Query (pdf)

• Using PL/SQL to Drop Schema Tables and Sequences (pdf)

SQL (return to top of page)

• NVL2...Why Didn't They Tell Us?

• "Where are the flashbacks they all warned us would come?" Flashback Query with Oracle9i

• JOINing Today's World...or...If Oracle Supports ANSI, so Should You!

• Dear Oracle...When is Thanksgiving?

• CTAS...For When You Need the Table, But Not the Data (pdf)

• Go ANSI Standard...and Add the Full Outer Join to Your Toolkit (pdf)

• Managing Relay Race Data - Part 1 The Interval Datatype (pdf)

• Managing Relay Race Data - Part 2 The Top N Query (pdf)

• Managing Relay Race Data - Part 3 The Rank Function (pdf)

• Managing Relay Race Data - Part 4 The Lead and Lag Functions (pdf)

• Managing Relay Race Data - Part 5 The FIRST_VALUE Function (pdf)

• Eliminating Duplicates with the Rank Function (pdf)

• Insert or Update? Indate? Upsert? Merge! (pdf)

• "Relationships - We all got 'em, we all want 'em. What do we do with'em?" Using a Hierarchical Query to Show Parent-Child Relationships (pdf).

• Serve up your Menu With a Hierarchical Query (pdf)

• "We will control the horizontal. We will control the vertical." The SQL Pivot Query (pdf)

• The Playoff Race is On...But What has That to do with Oracle? (pdf)

• There and Back Again. Using SQL to Calculate Distance (pdf)

• Time Zones (and Finding Paris) (pdf)

• Time Zones (and What Time is it in Paris?) (pdf)

UNIX / Linux (return to top of page)

• Using sed to Follow the Bouncing Database

• "But All I Wanted Was Yes or No, Did It Run or Not!"...sed and awk to the Rescue

• Red Hat Linux...Oracle10gR1 to Oracle10gR2...a Few Little Gotchas!

• The Oracle Password File, ORA-1991, and chmod

• Oracle Disk Devouring Files II...Archive Log Files (UNIX)

• Eliminate SQL*Plus Hangups with nohup (pdf)

• Free your SPFILE with Symbolic Links (pdf)

• grepping Through the Directory Tree with Recursive grep (pdf)

• Joins Aren't Just for Databases! The UNIX join Command (Plus a Little awk) (pdf).

• oerr...Your Guide to Oracle Errors for UNIX & Linux (pdf)

• A Windows File in a UNIX World. Removing Those Annoying Control-M's (^M) Using vi and sed (pdf)

Windows (return to top of page)

• Patching the Patch Set Notes...Oracle10g Release 2 (10.2.0.2) Patch Set for Windows

• Cloning a Windows Database...A Checklist

• Is My EXE Running?

• Windows SOS (Shutdown Oracle Safely)

• Oracle Disk Devouring Files III...Archive Log Files (Windows)

Other Stuff (return to top of page)

• New Philadelphia Area Oracle User Group

• Oracle Tips from the Real World...52 Weeks with Alydan Consulting

• Conversations about Certification

• Even an Oracle Guy Needs a Vacation (pdf)

2000 Turnberry Circle, Glenmoore, PA 19343
Voice: (610) 942-1979
Fax: (610) 942-1990
Email

© 2006 Alydan Consulting, Inc.