Search Results

sys_date=`date '+%d_%m_%Y:%H:%M:%S'`
sysdate1=`date '+%d_%m_%Y`
sqlplus -s $ORA_CONN << EOF
SET SERVEROUTPUT ON
SET FEED OFF
spool org.txt
BEGIN
FOR i IN (SELECT ID FROM table ID<>0)
...

In Oracle 10g and later you can use the dbms_scheduler package to execute external programs. In earlier versions this was done using dbms_java or dbms_pipe.
A full description can be found in the...

If I m not wrong, you are trying to execute same query for 25 column ids on a customer table at a single time.

For that your following qeury will list out column ids in abc.txt file. Correct?
...

run all scripts in background. create one script like below.

#!/bin/ksh
./script_name.ksh 1 &
./script_name.ksh 2 &
...
./script_name.ksh 25 &

then execute this script

./allScripts.ksh

awk -F ":20[:|C:|D:]" '{print $2}' infile

Try: perl -l -0044ne '/:20(?:C|D)?:(.*)/;print $1' input > output

If you use backticks you need to use extra escape(s) for the dollar sign, otherwise you are counting linefeeds instead of dollar signs. With the $() construct the extra escapes are not necessary.