Display Column Names Not Found In Procedures

This was written as a solution to a question posed on ITToolBox. Because of it's length, it is stored as an attachment: Cols_Procs.Sql

• It accepts a table name from the user.


• It finds all the source names where the table name supplied is found in the text.


• Based on that list, it creates a list of all the words in the text.


• These words are spooled, and then an external table is created.


• This external table is then compared against User_Tab_Columns for column names in that particular table.