what is the use of unix shell scripting with oracle?

Question

how to combine oracle with unix shell scripting?

Answer 1

You can use a Unix Shell Script to run commands within Oracle that can be run from the unix shell intarface (from the command line).

Like running sqlplus commands from the command line

% sqlplus /

You can use a shell script to string together several commands


#!/bin/sh

sqlplus /
sqlplus /
sqlplus /
sqlplus /

Answer 2

This is really a bit apples and oranges. Oracle is a RDBMS, UNIX shell scripting executes commands on a box with a UNIX OS. The shell scripts can contain Oracle commands through the use of SQL*PLUS.