On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Friday, October 10, 2008

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.

No comments:

Post a Comment