Search Results

I have executed the below query

cat pol.sh
RACLE_SID=DB01;
export ORACLE_SID;to get it to work.

MYDATE='20091113'
echo "MYDATE=$MYDATE"
SQL_OUTPUT=$(sqlplus -s wlportal/wlportal <<END
SET...

Changed to SQL Query to

select A.IS_REGRADE_ORDER from wlportal.orders a where A.TRACKING_NUMBER = '$orders';

Ouput : Throwing an error

I want to store the sql query output into a variable


#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp

# Order Checking
echo " removing old files "
rm...

After running the below sql query

select ename,eid,edate from emp where trunc(edate) = trunc(to_Date(sysdate))


output is

Ename Eid Edate
-----------------
xyz 987 8-11-2009
abc ...

Hi ,

I used the below script to get the sql data into csv file using unix scripting.

I m getting the output into an output file but the output file is not displayed in a separe columns .

...

Hi Scottn,

The script posted by you does not match , please post the correct script

A folder contains 30-50 subfolders generated on a daily basis, each subfolder contains more than 10-20 files of .html.gz files format. we have to manually convert the .html.gz file to .html format on...