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.