The title of this post is atrocious, I know, and, I apologize- I'm just not really sure how to neatly and succinctly sum up what I am attempting.
I am building an add-in to assist with my company's end-of-year financial processes. Part of this process is running some SQL scripts. I had the idea of incorporating, as a part of the add-in, a menu that would allow the user to choose and generate a pre-defined SQL script. The issue that I am having is how to store those scripts. I have 12 SQL scripts, each of them sitting in their own .txt file; I have attached a sample to this thread.
I want a user to be able to click on a custom add-in tab in their ribbon where they will be able to pick any one of 12 SQL scripts which will then copy the script to the clipboard so that the user can then paste it into a window in PL/SQL to be able to run it.
How would you fine people go about accomplishing this? I'm not looking for code, just methods. Any and all input would be greatly appreciated.
Many, Many, Many Thanks,
Justin
Bookmarks