Sponsored Content
Top Forums Shell Programming and Scripting Output coming in different line instead of single line Post 302345073 by mac4rfree on Tuesday 18th of August 2009 11:06:53 AM
Old 08-18-2009
Output coming in different line instead of single line

Hi Guys,

I have an oracle database, I am trying to query the database and route it to file.

But the records instead of coming in a single line, are coming in three lines.

Can you please help me.. in this..

Code:
sqlplus -s $SRMUserid/$SRMPassword@$SRMServer<< EOF >log.out;
select * from cisdba.s_rot where rownum=1;
exit
EOF
>cat log.out

    OBJ_ID   CLASS_ID   OBJ_TYPE S S_ROT_TIME_ S_ROT_USR_ID S_ROT_IS_PRIVATE
---------- ---------- ---------- - ----------- ------------ ----------------
S_ROT_OBJ_TEMPL_PTR BOTTOM_CLASS_ID S_ROT_CREATE_USR_ID S_ROT_ATT_COUNT
------------------- --------------- ------------------- ---------------
S_ROT_NOTE_COUNT S_ROT_CREAT S_ROT_TEMPLATE_KEY   S_SITEM_OWNER_GROUPSS
---------------- ----------- -------------------- ---------------------
    168634        120          1 C 19-MAR-2001        52001                0
                                120               52001               0
               0 19-MAR-2001

It should be
Code:
   OBJ_ID   CLASS_ID   OBJ_TYPE S S_ROT_TIME_ S_ROT_USR_ID S_ROT_IS_PRIVATE S_ROT_OBJ_TEMPL_PTR BOTTOM_CLASS_ID S_ROT_CREATE_USR_ID S_ROT_ATT_COUNT S_ROT_NOTE_COUNT S_ROT_CREAT S_ROT_TEMPLATE_KEY   S_SITEM_OWNER_GROUPSS
---------- ---------- ---------- - ----------- ------------ ----------------------------------- --------------- ------------------- ------------------------------- ----------- -------------------- ---------------------
    168634        120          1 C 19-MAR-2001        52001                0            120               52001               0               0 19-MAR-2001

Thanks for your help..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multi-line output to single line

Hello, How can I take the following output: outputa outputb outputc and turn it into single line ouput, with a single space between each field like below: outputa outputb outputc (7 Replies)
Discussion started by: LinuxRacr
7 Replies

2. AIX

ls command output in single line

Hi, Can anyone suggest me how can I display the output of ls command in single line with some delimiter say pipe (|)? I know it can be done by writing a script by using the loops but I wanted to know are there any other single line commands? Thanks for your help Sheshadri (7 Replies)
Discussion started by: arsheshadri
7 Replies

3. Shell Programming and Scripting

single line input to multiple line output with sed

hey gents, I'm working on something that will use snmpwalk to query the devices on my network and retreive the device name, device IP, device model and device serial. I'm using Nmap for the enumeration and sed to clean up the results for use by snmpwalk. Once i get all the data organized I'm... (8 Replies)
Discussion started by: mitch
8 Replies

4. Shell Programming and Scripting

Output to be in single line

Hi All, Small script but :wall:, please help in this regard. for i in 1 2 3 do echo $i done result : 1 2 3 I want the above to be printed as below expected result: 1 2 3 Thanks in advance :) (3 Replies)
Discussion started by: girish_satyam
3 Replies

5. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

6. Shell Programming and Scripting

Joining multi-line output to a single line in a group

Hi, My Oracle query is returing below o/p ---------------------------------------------------------- Ins trnas value a lkp1 x a lkp1 y b lkp1 a b lkp2 x b lkp2 y ... (7 Replies)
Discussion started by: gvk25
7 Replies

7. Shell Programming and Scripting

Output to single line

Hi, I am using below command and getting below output. echo "dis ql(*) CLUSTER"|runmqsc CT.QM.ASSA10T1| egrep 'QUEUE|CLUSTER'|egrep -v 'SYSTEM|XMITQ'| sed -e 's/QUEUE(/ /g' -e 's/TYPE(QLOCAL)/ /g' -e 's/CLUSTER(/ /g' -e 's/)/ /g' output CT.CL.ALLUHUB.FLST_TO_HUB_PROV.01... (20 Replies)
Discussion started by: darling
20 Replies

8. Shell Programming and Scripting

convert single line output to multiple line

Hi all, I have a single line output like below echo $ips 10.26.208.28 10.26.208.26 10.26.208.27 want to convert above single line output as below format. Pls advice how to do ? 10.26.208.28 10.26.208.26 10.26.208.27 Regards Kannan (6 Replies)
Discussion started by: kamauv234
6 Replies

9. UNIX for Beginners Questions & Answers

Output to file print as single line, not separate line

example of problem: when I echo "$e" >> /home/cogiz/file.txt result prints to file as:AA BB CC I need it to save to file as this:AA BB CC I know it's probably something really simple but any help would be greatly appreciated. Thank You. Cogiz (7 Replies)
Discussion started by: cogiz
7 Replies

10. UNIX for Beginners Questions & Answers

Get an output of lines in pattern 1st line then 10th line then 11th line then 20th line and so on.

Input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies
RNEWS(1)						      General Commands Manual							  RNEWS(1)

NAME
rnews - receive news from a UUCP connection SYNOPSIS
rnews [ -h host ] [ -v ] [ -U ] [ -N ] [ -S master ] [ input ] DESCRIPTION
Rnews reads messages typically queued by a UUCP newsfeed and sends them to the local InterNetNews server. The message is read from the specified input file, or standard input if no input is named. When sent over UUCP, Usenet articles are typically joined in a single batch to reduce the UUCP overhead. Batches can also be compressed, to reduce the communication time. If a message does not start with a number sign (``#'') and an exclamation point, then the entire input is taken as a single news article. If it does start with with those two characters, then the first line is read and interpreted as a batch command. If the command is ``#! rnews nnn'' where nnn is a number, then the next nnn bytes (starting with the next line) are read as a news article. If the command is ``#! cunbatch'' then the rest of input is fed to the compress(1) program with the ``-d'' flag to uncompress it, and the output of this pipe is read as rnews's input. This is for historical compatibility -- there is no program named cunbatch. A compressed batch will start with a ``#! cunbatch'' line, then contain a series of articles separated by ``#! rnews nnn'' lines. If the command is any other word, then rnews will try to execute a program with that name in the directory /usr/lib/news/rnews. The batch will be fed into the program's standard input, and the standard output will be read back as input into rnews. If rnews detects any problems with an article such as a missing header, or an unintelligible reply from the server, it will save a copy of the article in the /var/spool/news/in.coming/bad directory. OPTIONS
-S If the ``-S'' flag is used, then rnews will connect to the specified host. If the flag is not used, it will try to connect to the server by opening a Unix-domain stream connection. If that fails, it will try to open a TCP connection to the default remote server. -U If the server is not available, the message is spooled into a new file created in the /var/spool/news/in.coming directory. The ``-U'' flag may be used to send all spooled messages to the server once it becomes available again, and can be invoked regularly by cron(8). -N Normally, if unpacking the input fails it is re-spooled to /var/spool/news/in.coming for another attempt later. If the ``-N'' flag is used then no such re-spooling is done and rnews exits with status value ``9'' to indicate this. -v If the ``-v'' flag is used, it will print a notice of all errors on the standard error, naming the input file (if known) and print- ing the first few characters of the input. Errors are always logged through syslog(3). -h If the ``-h'' flag is given, or failing that, the enviroment variable UU_MACHINE is set, then rnews will log the Message-ID, and host, for each article offered to the server via syslog(3). Logging will only be done if the value is not an empty string. BUGS
Rnews cannot process articles that have embedded 's in them. HISTORY
Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews. This is revision 1.23, dated 1996/11/08. SEE ALSO
innd(8). RNEWS(1)
All times are GMT -4. The time now is 11:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy