Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
I tried this:
for region in 'raj' 'kt' 'kol' 'krl' 'chn' 'dl' 'hr' 'bih' 'ap'
do
sqlplus -s huw$region/`echo $region`huw#321@huw$region<<!
set serveroutput on
begin
select count(*) from tcd_preferred_cust_201109
end;
/
exit;
done
but the error shows like:
Syntax error at line 4 :... (1 Reply)
Hi all,
I have a file which I want to split into several files based on a condition. This files has several records. I want one record per file. Each record ends with a //. So, I want to separate files based on this condition. I want split files to be named with the name across the field ID (for... (2 Replies)
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Hi ,
Please excuse me for opening a new thread i am unable to find out the syntax error
in my if else condition inside for loop in awk command ,
my actual aim is to print formatted html td tag when if condition (True) having string as "failed",
could anyone please advise what is the right... (2 Replies)
Hi,
facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there.
ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Hi,
I need to perform the untar and rm operation if the file found is a .tar and does not have test.tar or hello.tar as the file names.
Below is the loop to check the same.
for tf in *.tar
do if ]
then found=1
... (1 Reply)
Discussion started by: mohtashims
1 Replies
LEARN ABOUT DEBIAN
beef
BEEF(1) User Commands BEEF(1)NAME
beef - flexible Brainfuck interpreter
SYNOPSIS
beef [OPTIONS] FILE
DESCRIPTION
beef is a Brainfuck interpreter written in C. It is written with flexibility and portability in mind: it is not the smallest nor the
fastest Brainfuck interpreter on Earth, but it has some options to control his behavior and doesn't suffer most of the limitations which
are usually present in Brainfuck interpreters.
One of the best features of beef is that it has no limitations on the length of the tape, which is created dinamically, and allows you to
move in any direction, even to move an unlimited amount of cells left when you are on the starting cell.
beef also allows you to control his behavior in case it reads and EOF from the input stream: see below for a list of available options.
OPTIONS -d Enable debugging. The debugging command # is not part of the Brainfuck language, but it's an useful feature for the programmer, so
most interpreters implement it. Debugging is off by default.
-e When read an EOF from input, store an EOF in the current cell. This is for compatibility with programs written for other inter-
preters; the default behavior is to store a 0 in the current cell when an EOF is read.
-n When read an EOF from input, do nothing. This is the default behavior in some other interpreters, so it's supported in beef for com-
patibility reasons. The default behavior is to store a 0 on the current cell instead.
--version
Show the version number and exit successfully.
--help Show a short help message and exit with success.
EXIT STATUS
beef returns an exit staus of zero on success, or an exit status of -1 if it was unable to perform the requested operation.
Please note that no checks are performed on the code: if the code you are trying to run is buggy, beef will run it anyway and the result
will probably differ from what you expected.
AUTHOR
This manual page was written by KiyuKo <eof AT kiyuko DOT org>
0.0.6 February 01, 2007 BEEF(1)