How to create a GUI front end to create customized batch scripts
Posted on 2009-04-21
First off, I admittedly know very little about programming. With that said, it seems as though what I want to program should be fairly simple to do. Below is my objective:
I'd like to create a GUI front end to automate the creation of batch scripts depending on the input I've given in the GUI itself. The output would create batch scripts that expand tablespace sizes in Oracle databases.
I already know how to write the batch scripts but I'd like to be able to somewhat automate the process to make it quicker and easier for me and my teammates.
Basically I just want the script to have two columns. One for the tablespace name and the other for the size of the tablespace which could compute how many total tablespaces need to be created (for example, if the maximum tablespace size is 1 gig and I need 4 gigs of tablespace, it would know to create 4 lines in the batch script with each tablespace name increasing, i.e. table01.dbf, table02.dbf, etc.).
Then I'd simply like for there to be some sort of execute button to create the batch script and run it.
I know about autoextending tables and ASM but that's not my objective right now. I'm trying to create a simple GUI to automate the creation of these batch scripts.
Any help would be greatly appreciated. If I should use a language other than C+ let me know. One guy suggested using an Oracle language that is web-based but that's not really what I'm looking to do. Thanks in advance.