Search Results

Korn shell

#!/bin/ksh
#
# Oracle and UNIX
#
uid="userid"
pwd="password"
dbms="remote.com"
parm=" 'A1234' "

list=`sqlplus -s <<EOF
$uid/$pwd
set heading off
set pagesize 0
set tab off
SELECT...

Do it all in PL/SQL

UTL_FILE.FOPEN()
LOOP

EXIT WHEN End of file

UTL_FILE.GET_LINE()
Perform update using TradeNo

END LOOP
UTL_FLE.FCLOSE()

Thank you everyone for your suggestions.

I am on SUN-OS box
I do not have the GNU grep
I do not have the cgrep
I can utilize the other suggestions...

Thanks once more...

A Tagore

Also try:

:e# to edit alternate file
and then
:e! to return to current file at time of last write

Then there is
:e file2 to edit file2 without leaving vi

Howz bouts thiz
(1) Write a SQL script to spool data to a file
(2) Write UNIX script to invoke SQL script

Example:
(1)
/*
This is SQL script named: get_emp.sql
*/
spool ascii.txt...

When searching for "text" in a file,
I would like to see the line containing "text"
and the line preceeding
and the line after
So I would like a 3 line output for each line matched by grep
Is...