Sponsored Content
Full Discussion: Running in a loop in UNIX
Top Forums Shell Programming and Scripting Running in a loop in UNIX Post 303014155 by balajesuri on Tuesday 6th of March 2018 06:18:23 AM
Old 03-06-2018
Code:
#! /usr/bin/zsh

query="set pagesize 0 feedback off verify off heading off echo off;
select table_name, table_name1 from table;"

while read line
do
    table_name=$(echo $line | awk '{print $1}')
    table_name1=$(echo $line | awk '{print $2}')
    echo $table_name, $table_name1
done <<< $(echo $query | sqlplus -S test/test)

You may try to optimise further.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Nested loop not running using cronjob

Hi I have created a shell script which uses three nested loops. When the cronjob is running the script there is a for loop which call a function which has two nested for loops. It is going into the function but the for loop in the function is not running. Can someone pleasae give me a solution... (9 Replies)
Discussion started by: bihani4u
9 Replies

2. Shell Programming and Scripting

running command in while loop

I have a script that users a while read, whithin this I want to execute the cp -i command on some of the results, however because it is in a loop it skips the -i part of cp. How do I get the loop to stop each time cp -i is run and wait for the user to type the response. (2 Replies)
Discussion started by: gefa
2 Replies

3. Shell Programming and Scripting

running a batch file in loop

i have a batch file which should run every five min...for an hour can any one help me out (1 Reply)
Discussion started by: aemunathan
1 Replies

4. Shell Programming and Scripting

loop when process running

Hi Gurus, Could you please help me to create a shell script that will be started by a cron job once every night at 24.00 h (that should bee easy:)) The shell script should control every 30 seconds the name of a process, and when the process doesn't run anymore it should execute a few further... (12 Replies)
Discussion started by: blackwire
12 Replies

5. Shell Programming and Scripting

For loop and running 2 commands at once?

HI. I am trying to run 2 commands, using the "for x in a b c d" loop but i am having a hard time coding it... Here is what i have so far: for SERVER in SERVERA SERVERB SERVERC SERVERD SERVERE do ############################################################################### #... (5 Replies)
Discussion started by: Stephan
5 Replies

6. Shell Programming and Scripting

Running for loop on remote server

Hi, I'm having a problem performing for loop on remote server, i know this can be done with one liner but i'm not sure how it works if using logical operator such as for ifs and case or while for server in sterverA serverB serverC ; do ssh -v $server "cd ~/MyDocuments/; bag=`find... (6 Replies)
Discussion started by: sexyTrojan
6 Replies

7. Shell Programming and Scripting

Help Running Loop Script

Hi I have a file called lastlogin_1 that contains a list of usernames. I would like to put together a quick loop script that will use a variable (the contents of lastlogin_1 file) and grep all directories and sub directories in the current directory (/in/the/current/directory) for each username... (3 Replies)
Discussion started by: jamba1
3 Replies

8. Shell Programming and Scripting

While loop running after reaching limit

Hi frnds i am newbie in linux and trying to write a simple script for adding users.the problem is i am running a while loop under function and loop is running for 3 time more than limit.Here is my Script and output pls help me out : # CREATE N NO. OF USERS WITH PASSWORD IN SYSTEM #... (4 Replies)
Discussion started by: Vaibhav.T
4 Replies

9. Shell Programming and Scripting

While Loop not running

echo "The recreate was successfully completed for device file $LCL_CLN_FILE." >> $LOG_FILE remaining=$(symclone -sid $LCL_SID -f $ETC/$LCL_CLN_FILE query | grep MB | awk '{print $2}') if then while do echo "$remaining MB's to be copied........." >> $LOG_FILE ... (10 Replies)
Discussion started by: rajsan
10 Replies

10. Shell Programming and Scripting

While loop is running only for the first iteration

Hello, I've written a script to automate encoding of all the MP4 files in a directory (incl. subdirectories). But unfortunately it's running for the first MP4 file only. My machine details: root@Ubuntu16:~# uname -a Linux Ubuntu16 4.10.0-28-generic #32~16.04.2-Ubuntu SMP Thu Jul 20 10:19:48... (2 Replies)
Discussion started by: prvnrk
2 Replies
UUX(1C) 																   UUX(1C)

NAME
uux - unix to unix command execution SYNOPSIS
uux [ - ] command-string DESCRIPTION
Uux will gather 0 or more files from various systems, execute a command on a specified system and send standard output to a file on a spec- ified system. The command-string is made up of one or more arguments that look like a shell command line, except that the command and file names may be prefixed by system-name!. A null system-name is interpreted as the local system. File names may be one of(1) a full pathname; (2) a pathname preceded by ~xxx; where xxx is a userid on the specified system and is replaced by that user's login directory; (3) anything else is prefixed by the current directory. The `-' option will cause the standard input to the uux command to be the standard input to the command-string. For example, the command uux "!diff usg!/usr/dan/f1 pwba!/a4/dan/f1 > !fi.diff" will get the f1 files from the usg and pwba machines, execute a diff command and put the results in f1.diff in the local directory. Any special shell characters such as <>;| should be quoted either by quoting the entire command-string, or quoting the special characters as individual arguments. FILES
/usr/uucp/spool - spool directory /usr/uucp/* - other data and programs SEE ALSO
uucp(1) D. A. Nowitz, Uucp implementation description WARNING
An installation may, and for security reasons generally will, limit the list of commands executable on behalf of an incoming request from uux. Typically, a restricted site will permit little other than the receipt of mail via uux. BUGS
Only the first command of a shell pipeline may have a system-name!. All other commands are executed on the system of the first command. The use of the shell metacharacter * will probably not do what you want it to do. The shell tokens << and >> are not implemented. There is no notification of denial of execution on the remote machine. UUX(1C)
All times are GMT -4. The time now is 12:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy