Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Simple Scritping Question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Simple Scritping Question
# 1  
Old 05-21-2010
Simple Scritping Question
Hi Guys,

I am writing a simple ksh script which contains some SQL. The SQL returns something like the following:-

**** ****** ********* ********* ********* ******** ********** ***** ********* ***** 176 rows selected.

The stars are usernames and there could be 0 or there could be 100 or more.

I need to strip the "*** rows selected." from the end of the string.

I don't think that I can use cut but maybe an awk or sed command would do it but I do not know these commands in depth.

Can anyone help please?

Thanks,

Ken.
# 2  
Old 05-21-2010
try
Code:
sed  '/row selected/d' result_file_name

# 3  
Old 05-21-2010
Thanks posix.

I am obviously being thick. Here is what I am trying to do:-


Log into Oracle using SQLPLUS
Code:
CreateEMUsers=`${SQLCMDNOLOG} <<!!
conn / as sysdba
set pages 0 echo off
SELECT **** from USERS****;
exit
!!`

So the result is similar to this:-

Code:
**** ****** ********* ********* ********* ******** ********** ***** ********* ***** 176 rows selected.

I am unsure how to incorporate your sed command into this.

THanks for your help,

Ken.

---------- Post updated at 09:31 AM ---------- Previous update was at 09:13 AM ----------

I tried sed '/row selected/d' < ${CreateEMUsers} > CreateEMUsersLOOP but it didn't work either!!
Last edited by Scott; 05-21-2010 at 06:20 AM.. Reason: Please use code tags
# 4  
Old 05-21-2010
You can easily do that thing in sql query it self i think
use
Code:
set feedback off

use before the select statement .
# 5  
Old 05-21-2010
I'm not white sure what your output format is: is it really a stream of names and the "xxx rows selected" are just the last words of this single line or is it a list (that is: each name/record on a separate line) and the "xxx rows selected" is in the last line of these?

If the first is the case:

Code:
CreateEMUsers="$(${SQLCMDNOLOG} <<-EOF | sed 's/[0-9]* rows* selected\. *$//'
conn / as sysdba
set pages 0 echo off
SELECT **** from USERS****;
exit
EOF
)"

If the latter is the case it is even easier - you just have to delete the last line:
Code:
CreateEMUsers="$(${SQLCMDNOLOG} <<-EOF | sed '$ d'
conn / as sysdba
set pages 0 echo off
SELECT **** from USERS****;
exit
EOF
)"

I hope this helps.

bakunin
# 6  
Old 05-21-2010
posix,

Of course. Thanks for your help. As a DBA, I feel a bit of an idiot now Smilie

Thanks,

Ken.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Syslog.conf: looking for a simple answer on a simple question

Cheers! In /etc/syslog.conf, if an error type is not specified, is it logged anywhere (most preferable is it logged to /var/log/messages) or not? To be more precise I am interested in error and critical level messages. At default these errors are not specified in syslog.conf, and I need to... (6 Replies)
Discussion started by: dr1zzt3r
6 Replies

2. Shell Programming and Scripting

Simple if then else question

I am having trouble making this statement work. I am passing in a number value for the number of days to keep archive logs for and wanted to make sure that it is a number. I have a script that will return 1 for is a number and 0 for is not a number. I also want to make sure that the number is not... (2 Replies)
Discussion started by: gandolf989
2 Replies

3. UNIX for Dummies Questions & Answers

simple question

hi everybody; trying to c unix programming and ive stucked with a problem: simple program filedr=open("tempfile",O_RDWR|O_TRUNC,0); write(filedr,msg1,6); int i; i=read(filedr,msg3,4); it returns 0 bytes read ... why? well if i try to poll() before read , it doesnt indicate POLLHUP or... (4 Replies)
Discussion started by: IdleProc
4 Replies

4. UNIX for Dummies Questions & Answers

Simple question

I had a script in solaris wich i read data, for example: Number 1: _ and the cursor use to be in '_' place because in the code of the script i write: echo "Number 1:\c" but i copy the script to a linux and the cursor 'jump' to the begining of the next line like: Number 1:... (2 Replies)
Discussion started by: lestat_ecuador
2 Replies

5. Shell Programming and Scripting

Simple Question

Hi, Please don't berate me over the simplicity of these questions. I have recently gotten into bash shell scripting and enjoy it quite a bit. One thing I have not found the answer to though is when naming a shell script, what extension is normally used (ie myscript.?)? Also where is the standard... (5 Replies)
Discussion started by: msb65
5 Replies

6. UNIX for Dummies Questions & Answers

Simple Question

Hi Guys, I've been learning UNIX for the past couple of days and I came across this exercise, I can't get my head around it, so I would be ever so grateful if I could receive some sort of help or direction with this. Create a file with x amount of lines in it, the content of your choice. ... (3 Replies)
Discussion started by: aforball
3 Replies

7. Programming

Simple C question... Hopefully it's simple

Hello. I'm a complete newbie to C programming. I have a C program that wasn't written by me where I need to write some wrappers around it to automate and make it easier for a client to use. The problem is that the program accepts standard input to control the program... I'm hoping to find a simple... (6 Replies)
Discussion started by: Xeed
6 Replies

8. UNIX for Dummies Questions & Answers

Ok simple question for simple knowledge...

Ok what is BSD exactly? I know its a type of open source but what is it exactly? (1 Reply)
Discussion started by: Corrail
1 Replies

9. UNIX for Advanced & Expert Users

Simple Question

Friends, I did following exercise $ echo '' > test $ od -b test $ echo "">test $ od -b test $echo > test $od -b test Every time I got the following output 0000000 012 0000001 But 012 is octal value for new line character . Even though there is no apperent new line character... (6 Replies)
Discussion started by: j1yant
6 Replies

10. UNIX for Dummies Questions & Answers

Simple question?

I've been a Linux user for quite some time, started out with Red Hat and Mandrake, and just recently moved to Slackware linux.... my question is this: Is there a big difference between Linux and Unix? If so, what? I was just looking at Sun's Solaris 8 thats free for download on Intel... (5 Replies)
Discussion started by: Cuthbert
5 Replies
Login or Register to Ask a Question