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:
However, when trying to call @insert_table_counts_master.sql i am not able to pass the ${VARIABLE} variable to that same script.
ie I want also to pass ${VARIABLE} to the script insert_table_counts_master.sql
The script insert_table_counts_master.sql is as follow:
Example output would be;
Question is, how can I pass the ${VARIABLE} to the called sql script?
Thanks for any help,
jd
Last edited by vbe; 04-17-2019 at 01:22 PM..
Reason: extra code tags
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)
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 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)
Hi all,
Hereby wish to have your advise for below:
Main concept is
I intend to get current directory of my script file.
This script file will be copied to /etc/init.d.
A string in this copy will be replaced with current directory value.
Below is original script file:
... (6 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)
I want to make a config file which contain all the paths.
i want to read the config file line by line and pass as an argument on my below function.
Replace all the path with reading config path line by line and pass in respective functions.
how can i achieve that?
Kindly guide.
... (6 Replies)
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT OSF1
stl_mi
stl_mi(4) Kernel Interfaces Manual stl_mi(4)NAME
stl_mi - Software distribution master inventory files
DESCRIPTION
Each software product that is distributed as subsets for the setld(8) command has an associated master inventory file. The master inventory
file's name consists of the product's unique 3-letter name and a 3-digit version number with the string .mi for a suffix. The master inven-
tory file is used by the software kitting program kits(1) in producing software distribution packages.
A master inventory file contains one ASCII record, describing vendor-specified attribute information, for each file in the product kit.
Each record is composed of three fields which must be separated by TAB characters. The fields are: A 16-bit unsigned integer.
Bit 1 is the v (volatility) bit; when it is set, changes to the existing copy of the file can occur during kit installation. It is
usually set for log files required by applications. The remaining bits are reserved. Possible values for this field are therefore 0
or 2. The dot-relative (./) pathname of the file described by this record. Each pathname must appear only once in the master
inventory file. Pathnames must begin with a period (.). Records must be sorted in ascending ASCII sequence on this field. The name
of the subset containing the file. Standard system directories are not included in subsets; they are represented by the keyword
RESERVED in place of a subset name. Files that exist in the product hierarchy but are not distributed as part of any subset have a
minus sign (-) in this field. Files that share a gnode (links) must all be included in the same subset.
EXAMPLES
This example shows a section of the master inventory for a hypothetical layered product kit: 0 . RESERVED 0 ./usr/opt
RESERVED 0 ./usr/opt/OAT100 OATDCB100 0 ./usr/opt/OAT100/bin OATDCB100 0 ./usr/opt/OAT100/bin/attr OATDCB100 0
./usr/opt/OAT100/bin/dcb.spr OATDCB100 0 ./usr/opt/OAT100/bin/dcb_defaults OATDCB100 0 ./usr/opt/OAT100/bin/dcb_diag.sed
OATDCB100 0 ./usr/opt/OAT100/bin/docbld OATDCB100 0 ./usr/opt/OAT100/bin/unstamp OATDCB100 0 ./usr/opt/OAT100/lib OATDCB100 0
./usr/opt/OAT100/lib/br OATDCB100 0 ./usr/opt/OAT100/lib/br/README.dcb OATDCB100 0 ./usr/opt/OAT100/lib/br/attr.1
OATDCBDOC100 0 ./usr/opt/OAT100/lib/br/dcb.ps OATDCBDOC100 0 ./usr/opt/OAT100/lib/br/docbld.1 OATDCBDOC100 0
./usr/opt/OAT100/lib/br/docbld.5 OATDCBDOC100 0 ./usr/opt/OAT100/lib/br/unstamp.1 OATDCBDOC100 0 ./usr/opt/OAT100/lib/doclib
OATDCB100 0 ./usr/opt/OAT100/lib/doclib/templates OATDCB100 0 ./usr/opt/OAT100/lib/doclib/templates/conv.braces OATDCB100 0
./usr/opt/OAT100/lib/doclib/templates/conv.command OATDCB100 . . .
RELATED INFORMATION invcutter(1), kits(1), newinv(1), setld(8) Guide to Preparing Product Kits delim off
stl_mi(4)