I’ve always been a mediocre programmer at best and thus reaching out for help here since I don’t even know where to start.
A short explanation of what I’m trying to accomplish: I need to create a simple program that connects to an Oracle DB, gets input in the from the user in the form of short numeric values, uses that variable to run simple SQL queries in the background and returns a pretty result, like “%value%
%%%% found / not found”.
The reason behind this is that this is intended for managers and non-tech users. I managed to get authorization for a set of read-only credentials to be used for this project but I guess the whole thing comes from trying to avoid giving out those credentials (for compliance reasons) plus 99% of those users not having a clue how to use them anyway.
This can either be a GUI or a command line program and should, ideally, be contained within a single executable and be as uncomplicated and easy as possible to use for those non-tech users.
Connection to the DB is only possible within our network, so security aside from not having to release the credentials is not an issue.
Any ideas, advise, comments or suggestions as to where to start or look out to?
Thanks in advance,