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
xmlparsing
xmlparsing(3) Coin xmlparsing(3)NAME
xmlparsing - XML Parsing with Coin For Coin 3.0, we added an XML parser to Coin. This document describes how it can be used for generic
purposes.
Why another XML parser, you might ask? First of all, the XML parser is actually a third-party parser, expat. Coin needed one, and many
Coin-dependent projects needed one as well. We therefore needed to expose an API for it. However, integrating a 3rd-party parser into Coin,
we can not expose its API directly, or other projects also using Expat would get conflicts. We therefore needed to expose the XML API with
a unique API, hence the API you see here. It is based on a XML DOM API we use(d) in a couple of other projects, but it has been tweaked to
fit into Coin and to be wrapped over Expat (the original implementation just used flex).
The XML parser is both a streaming parser and a DOM parser. Being a streaming parser means that documents can be read in without having to
be fully contained in memory. When used as a DOM parser, the whole document is fully parsed in first, and then inspected by client code by
traversing the DOM. The two modes can actually be mixed arbitrarily if ending up with a partial DOM sounds useful.
The XML parser has both a C API and a C++ API. The C++ API is just a wrapper around the C API, and only serves as convenience if you prefer
to read/write C++ code (which is tighter) over more verbose C code.
The C API naming convention may look a bit strange, unless you have written libraries to be wrapped for scheme/lisp-like languages before.
Then you might be familiar with the convention of suffixing your functions based on their behaviour/usage meaning. Mutating functions are
suffixed with '!', or '_x' for (eXclamation point), and predicates are suffixed with '?', or '_p' in C.
The simplest way to use the XML parser is to just call cc_xml_read_file(filename) and then traverse the DOM model through using
cc_xml_doc_get_root(), cc_xml_elt_get_child(), and cc_xml_elt_get_attr().
See also:
XML related functions and objects, cc_xml_doc, cc_xml_elt, cc_xml_attr
Version 3.1.3 Wed May 23 2012 xmlparsing(3)