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.


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.