| 1. |
Configuration Management
A must-read for the serious application developer, this article discusses aspects of application development such as: Application Disaster Recovery, Requirements, Documentation, Change Management and Testing. |
| 2. |
Dynamic SQL without DBMS_SQL
Did you know you can create SQL statements dynamically? You can with REF CURSOR and EXECUTE IMMEDIATE. |
| 3. |
Employment or Consulting?
If your thinking of making the move to from employee to contractor or consultant, this article will point out some issues you should consider. This article is from IT Recruiter, August 1999. |
| 4. |
How to interview for an IT job
Steve O'Hearn has been in hundreds of interviews both as interviewer and interviewee. This article will provide you with a few pointers to boost your confidence before an interview. This article first appeared in IT Recruiter magazine, June 1999. |
| 5. |
How to prepare a resume for the IT industry
An in-depth discussion of resume dos and don'ts from an industry expert. This article first appeared in IT Recruiter's, High Tech Track column. |
| 6. |
MAOP and other Professional Associations Can Help Advance Your IT Career
See why professional associations are beneficial especially to the IT professional. At a MAOP (Mid-Atlantic Association or Oracle Professionals) conference you can keep your skills fresh as well as meet others in your industry. This is from IT Recruiter, May 1999. |
| 7. |
Oracle 9i Support for ANSI Join Syntax
With the release of 9i, Oracle has included support for ANSI syntax for joins. Oracle Corp. actually recommends using the ANSI syntax for outer joins as
opposed to the traditional (+) operator. |
| 8. |
PL/SQL Collections - Varrays and Index-by Tables
Using PL/SQL Varrays and Index-by tables (PL/SQL tables) as a substitute for long IF statements. As well as using sort algorithms on PL/SQL collections. Keywords: VARRAY, TYPE, RECORD, INDEX BY, TABLE OF, BINARY_INTEGER |
| 9. |
PL/SQL Encryption - DBMS_OBFUSCATION_TOOLKIT
Demonstrates the use of the DBMS_OBFUSCATION_TOOLKIT to encrypt data with PL/SQL. This article also discusses the Wrap Utility for encrypting PL/SQL source code. |
| 10. |
Resume and Interview Tips From A Professional Career Advisor
Doug Jones has several years of experience as career advisor. In this article he shares trade secrets of successful resume writing, including an inside look at a typical Human Resources hiring process. |
| 11. |
Sending Emails with the UTL_SMTP Package
Sending email from a PL/SQL procedure can connect your application to the world. |
| 12. |
Using The DBMS_JOB Package
The DBMS_JOB package provides a way for you to schedule procedures to execute at a specific time. |
| 13. |
Using the DBMS_RANDOM Package
DBMS_RANDOM can be used to generate a random number. This article shows you how to use this package to send a random quote via email. Also, discusses using the ABS and MOD functions. |
| 14. |
Using the UTL_FILE Package
UTL_FILE can be used to enable PL/SQL to interact with the file system by allowing for simple I/O. This article contains sample procedures which read, write and append data to and from text files. |
