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
po4aman-display-po
PO4AMAN-DISPLAY-PO(1) Po4a Tools PO4AMAN-DISPLAY-PO(1)NAME
po4aman-display-po - display a translated man page according to a PO
SYNOPSIS
po4aman-display-po -p PO_FILE [-m MASTER_FILE] [-o PO4A_OPT]
DESCRIPTION
po4aman-display-po can be used by a translator who wants to check how the man page being translated in a PO will be displayed.
The manual page must be in one of the formats supported by the po4a's man module. The manual page can be provided on the command line, or
installed on the system.
Manual pages generated from other formats, like DocBook or POD, are not supported. See po4apod-display-po(1) for an equivalent supporting
POD documents.
OPTIONS -p PO_FILE
The PO file containing the translations.
-m MASTER_FILE
The original man page. It can be the absolute or relative path to the original man page (gzipped or not), the name the man page or the
name and section of the man page (using the man.section format). When the master document is not provided with the -m option,
po4aman-display-po tries to find the original man page based on the line reference of the first string in the PO.
-o PO4A_OPT
Some options to pass to po4a-translate(1).
SEE ALSO po4apod-display-po(1)AUTHOR
Thomas Huriaux
Po4a Tools 2006-04-08 PO4AMAN-DISPLAY-PO(1)