Hi,
I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers.
Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
HI,
I want to connect to database and fetch the count from a table.
The sql query is as below :
select count(*) from table_test where test_column='read';
How can I print the output of this statement using shell script.
Thanks in advance. (4 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Hi Team,
I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:
#!/bin/bash
export ORACLE_SID=plgc1
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
export... (1 Reply)
Discussion started by: jonnyd
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)