Connect to sqlplus in a shell script and run SQL scripts

by

For example:

sqlplus -s admin/password << EOF
whenever sqlerror exit sql.sqlcode;
set echo off 
set heading off

@pl_script_1.sql
@pl_script_2.sql

exit;
EOF

More Related Contents:

  1. What does 2>&1 mean here?
  2. How to reload .bashrc settings without logging out and back in again?
  3. How do I iterate over a range of numbers defined by variables in Bash?
  4. Why would a correct shell script give a wrapped/truncated/corrupted error message? [duplicate]
  5. When do we need curly braces around shell variables?
  6. Bash command line and input limit
  7. Replace one substring for another string in shell script
  8. How to find the difference in days between two dates?
  9. How to assign the output of a Bash command to a variable? [duplicate]
  10. Running script upon login in mac OS X [closed]
  11. Command substitution: backticks or dollar sign / paren enclosed? [duplicate]
  12. Using the RUN instruction in a Dockerfile with ‘source’ does not work
  13. Why start a shell command with a backslash?
  14. How to process each output line in a loop?
  15. Is there a TRY CATCH command in Bash
  16. Set a parent shell’s variable from a subshell
  17. find: missing argument to -exec
  18. What does it mean in shell when we put a command inside dollar sign and parentheses: $(command)
  19. How does bash tab completion work?
  20. Is mixing getopts with positional parameters possible?
  21. Counting lines or enumerating line numbers so I can loop over them – why is this an anti-pattern?
  22. Execute command containing quotes from shell variable [duplicate]
  23. What does “export” do in shell programming? [duplicate]
  24. What is the most elegant way to remove a path from the $PATH variable in Bash?
  25. pipe stdout and stderr to two different processes in shell script?
  26. How can I convert tabs to spaces in every file of a directory?
  27. How to match a single quote in sed
  28. How do I integrate MSYS2 shell into Visual studio code on Window?
  29. Parse HTML using shell
  30. Renaming files with Bash, removing prefix and suffix

Leave a Comment