Summary: Hi I really appreciate on the below question. I have shell script which Sql plus to different Oracle db's . In between, if one of the SQLPlus fails du...
Summary: Hello Can anybody explain how I can ftp the reult of a sql script in a shell script that is executed via a cronjob??I would like the result to be se...
Summary: Hi i have written a shell script which runs some sql queries in oracle. the code looks like this sqlplus username@NJCMTOMS/password < $HOME/devel/o...
Summary: In shell script I am inserting the record in to the table.After excuation the script output is commit complete which is fine but I need my echo should...
Summary: I want to write a query in shell that retrieves the users from a user table in oracle and then send an email to the user list output. How can i do th...
Summary: Hi, I'm trying to run loops in shell scripts using the following script. loop=1 while [ loop -lt 10 ] do echo 'this is my $loop text-line' loop='expr ...
Summary: In shell script sed or awk command, can I use hexadecimal code for substitution? I want to perform the following: Input file: Line1 Line2 Line3 Line4...
Summary: Dear all, I wonder how to find the size of an array in shell script. For example, I declared an array as following: #! /bin/sh a = (1 adf 8 2 se) How ...
Summary: Hi guys, i have a file inside file file name are stored 1 filename per line i want to open the file and read each line from the file and process it......
Summary: I have a batch file that starts up the oracle, executes a query and spools the result to a text file and exits. The code goes like this... sqlplus ccn...
Summary: I need to know if the connection fails to the remote host in a shell script. Which error codes etc should I check for? What would be in the if stateme...
Summary: Richard: I'm not an Oracle guy, but check out "Using SQL in Shell Scripts" by Gleed and Tarvainen: http://www.samag.com/documents/s=1434/sam9505f/9505...
Summary: I have a problem with the translation of the following command in awk. In Shell the radiance-command work like that: gensurf seitenwand rollerblind1 '...
Summary: Shell Scripting -- Variables In the main script i have exported the variable and accessing it in another file but when i echo the value the value of t...
Summary: I am trying to fetch the records from oracle database and write on to xls file for that I did the following. I am trying to run the sql script from ho...
Summary: Thanks for your responses.. For data cleansing we were using Datastage (ETL tool)instead of that now we are doing it manually i.e by programming. We c...
Summary: Hi, I need help for a shell script to have a user enter a date into the program. When the date has been entered in format dd/mm/yyyy, i need the scrip...
Summary: Hi All, I would like to know whether programming in bourne shell,c,tsh shell all are or they have there own way of programming. Thanks, Jaya K ...
Summary: If the .csv file is reasonably small (say under 100K) try reading it from PL/SQL using UTL_FILE. Otherwise use SQL*Loader, which is very fast but does...
Summary: Hi, I need to run a command and hit 4 times in response to the prompts after the command is run. I don't know how to do this in a shell script. Could...
Summary: Hello, I want to give back the first 3 letters of my hostname to a variable in a shell script like this principle: N=awk'{printf substr(`uname -n`,1,3...
Summary: My code is like this : ----------------------- #!/bin/csh set main="/home/xyz" set tmp="$main/tmp" echo $tmp rm $tmp/* ----------------------- There a...
Summary: My first shell script logs into a shell, after setting some environment variables. After log into the shell, I call second shell script. This shell al...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
