Developer

Using a PL/SQL Table in SQL

A friend of mine called a few

days ago with a question. He wanted to populate a PL/SQL table and use

it to compare to some other data via a NOT IN subquery. He was having a

problem getting the data into the nested table and wasn't sure how to

access it from SQL after he did.

Because

he had the question and was having a problem implementing it, I figured

others might have the same issue. I wrote a very simple script showing how this can be done and thought I would post it here for you.

I am creating a test table and inserting some data. He was having an issue with a date field so that's what I'll use here.

Read the rest of this post.



http://blogs.ittoolbox.com/cgi-bin/mt/mt-tb.cgi?tb_id=8980

Editor's Picks