12-21-2011
Thanks a lot for your suggestion. I think i can generate XML directly now.. Great
---------- Post updated at 06:34 AM ---------- Previous update was at 05:59 AM ----------
Do you know how to write the XML created in oracle database in UNIX environment using shell script. is it possible to do it?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
3. Shell Programming and Scripting
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
Discussion started by: sureshcisco
0 Replies
4. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Discussion started by: jackmorgan2007
2 Replies
7. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
8. Shell Programming and Scripting
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Discussion started by: vsachan
12 Replies
9. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
10. Shell Programming and Scripting
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
LEARN ABOUT DEBIAN
update-xmlcatalog
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.14.2 2008-10-14 UPDATE-XMLCATALOG(8)