10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
2. Shell Programming and Scripting
Hi,
I'm having a xml file with multiple xml header. so i want to split the file into multiple files.
Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix.
eg :
<?xml version="1.0" encoding="UTF-8"?>
<ml:individual... (3 Replies)
Discussion started by: Narendra921631
3 Replies
3. Shell Programming and Scripting
Hi
How do I translate
Let say
Cat inserts.sql
gives
Insert into PM9_TAXATION_ROUNDING
(STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD)
Values
('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies
4. Shell Programming and Scripting
Hi ,
I have a below xml:
<ns:Body>
<ns:result>
<Date Month="June" Day="Monday:/>
</ns:result>
</ns:Body>
i have a lookup abc.txtt text file with below details
Month June July August
Day Monday Tuesday Wednesday
I need a output xml with below tags
<ns:Body>
<ns:result>... (2 Replies)
Discussion started by: Nevergivup
2 Replies
5. Shell Programming and Scripting
I've got two different files and want to compare them.
File 1 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies
6. Shell Programming and Scripting
Hi All,
I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me.
<A>testing_Location</A>
<value>LA</value>
<zone>US</zone>
<B>Region</B>
<value>Russia</value>
<zone>Washington</zone>
<C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies
7. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
8. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
9. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
10. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
UPDATE-XMLCATALOG(8) xml-core UPDATE-XMLCATALOG(8)
NAME
update-xmlcatalog - maintain XML catalog files
SYNOPSIS
update-xmlcatalog --add --root --package package --type type --id id
update-xmlcatalog --del --root --package package --type type --id id
update-xmlcatalog --add --package package --local local --type type --id id
update-xmlcatalog --del --package package --local local --type type --id id
update-xmlcatalog --add --local local --file file --type type --id id
update-xmlcatalog --del --local local --file file --type type --id id
update-xmlcatalog --help
DESCRIPTION
update-xmlcatalog add entries to and removes entries from the root XML catalog file, a package XML catalog file or a local XML catalog
file.
OPTIONS
--add
Adds the entry to the root XML catalog file, a package XML catalog file or a local XML catalog file. If the XML catalog file does not
exist yet, it is automatically created.
--del
Deletes the entry from the root XML catalog file, the package XML catalog file or the local XML catalog file. A resulting empty XML
catalog is not automatically deleted from the filesystem.
--file file
Indicates a local filename.
--id id
Indicates the XML catalog file entry identifier.
--local local
Indicates a local XML catalog file.
--package package
Indicates a package XML catalog file.
--root
Indicates the root XML catalog file.
--type type
Indicates the XML catalog file entry type (public, system, uri).
--help
Displays the usage information.
NOTES
update-xmlcatalog is the de-facto standard tool to be used to maintain XML catalog files on a Debian system, similar to that
update-catalog(8) is the standard tool to be used to main SGML catalog files on a Debian system. A Debian XML Policy document to this
effect is currently under development.
update-xmlcatalog and xmlcatalog(1) are incompatible. The former has an internal database of all the entries in all the XML catalog files
it maintains and regenerates the indicated XML catalog file completely from scratch upon an update. The latter updates the indicated XML
catalog file directly. This means that any change made to an XML catalog file using xmlcatalog(1) is overwritten the next time that XML
catalog file is updated using update-xmlcatalog.
SEE ALSO
/usr/share/doc/xml-core/README.Debian
AUTHOR
Ardo van Rangelrooij <ardo@debian.org>
perl v5.10.0 2008-10-14 UPDATE-XMLCATALOG(8)