Ask the Expert

PL/SQL code to implement ETL function

I was looking for some functions and procedures written in PL/SQL code that can implement ETL function. Where can I find this generic code? Who could help me to understand how PL/SQL works? Thank you.

    Requires Free Membership to View

I found a great example of a function written in PL/SQL that can implement ETL functions. See: Note:150740.1 at

To help you with learning PL/SQL, try Oracle Database 10g PL/SQL Programming by Scott Urman, Ron Hardman and Michael McLaughlin. I have been using this book for a couple of months. This book has helped me with answering questions for this Web site. Although 10g is in the title of this book, it also can be used as reference book for 9i users.

This was first published in August 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: