Linux Shell Script for Oracle DB
Budget: $10 – $30 USD
I'm looking for a shell script that connects to an Oracle database on a Linux system, executes a complex SQL query from a file, and spools the output to a text file with specific formatting requirements.
Key Requirements:
- The output should be fixed width, without headers or special characters (like commas or quotes) between columns.
- The script should have standard checks for errors. If any Oracle error occurs, the exit code should indicate failure. The same applies for any OS errors.
- The script should also include both exit codes and specific error logging for failures.
Ideal Skills:
- Proficiency in writing shell scripts for Linux.
- Deep understanding of Oracle database and SQL.
- Experience with error handling and logging in shell scripts.
- Ability to understand and implement specific output formatting requirements.
Key Requirements:
- The output should be fixed width, without headers or special characters (like commas or quotes) between columns.
- The script should have standard checks for errors. If any Oracle error occurs, the exit code should indicate failure. The same applies for any OS errors.
- The script should also include both exit codes and specific error logging for failures.
Ideal Skills:
- Proficiency in writing shell scripts for Linux.
- Deep understanding of Oracle database and SQL.
- Experience with error handling and logging in shell scripts.
- Ability to understand and implement specific output formatting requirements.