Shell Programming and Scripting

hi anbu,

after i run the script above i still got the blank line :

10.1.0.0 LDDS-IVR-2
10.1.0.0 LDDS-CS-A
10.1.0.0 USSDGsem1
10.1.0.0 USSDGsem2
10.1.0.0 USSDGsby1
10.1.0.0 USSDGsby2
10.1.0.0 USSDGmdn1
10.1.0.0 USSDGmdn2
10.1.0.0 USSDGtbs2
10.1.0.0 LDDS-IVR-1
10.1.0.0 USSDGtbs1
10.1.0.0 LDDS-MAP-B
10.1.0.0 LDDS-CS-B

10.1.0.0 LDDS-MAP-A
10.1.0.0 USSDGtbs3
10.1.0.0 USSDGmdn3
10.1.0.0 USSDGmdn4
10.1.0.0 USSDGsby3
10.1.0.0 USSDGsby4
10.1.0.0 USSDGtbs4



any ideas?

thank you

Best Regards,

bucci

#!/usr/bin/ksh
var=""
file="/dir/subdir/filename.ext"

var=`$ORACLE_HOME/bin/sqlplus -s username/password@db<<!
set pagesize 0 feedback off verify off heading off trimout on echo off
WHENEVER OSERROR EXIT SQL.OSCODE
WHENEVER SQLERROR EXIT SQL.SQLCODE
select column
from table
where columne = value
;
!`
echo ${var} >> ${file}

Try this

Code:

sed "/^ *$/d" file

hi anbu,

thank so much it work

Regards,

bucci

Hi,

The below script connecting to database and query the table put the o/p into file.

#!/bin/sh
var=""
file="/home/xx1/abc/filename.ext"
var=`$ORACLE_HOME/bin/sqlplus -s sd/sd@db1<<!
set feedback off;
set linesize 100;
select * from xx1;
!`
echo ${var}>>${file}


ORACLE
---------
select * from xx1

A B
P 123
Q 234
P 234

filename.ext in unix
------------------
P 123 Q 234 P 234

I want below format in that file

A B
P 123
Q 234
P 234

Please help

Thanks and Regards,
MR

Code:

echo "P 123 Q 234 P 234" | tr ' ' '\n' | paste -d" " - -

Hi,
I want to do it in inside the script (When executing the below script ,data loaded with column format)

Thanks and Regards,
MR