Search Results

Depends on which version of grep you have:

$ grep --version
grep (GNU grep) 2.5.1

Under the help:
Context control:
-B, --before-context=NUM print NUM lines of leading context
-A,...

UTL_FILE won't work if his database is running on a different machine than his shell script.

Try this.

$ cat use_oracle_proc.ksh
#!/bin/ksh

run_sql()
{
$ORACLE_HOME/bin/sqlplus -S...