Getting into SQL/XML Post: 302182293

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

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...

2. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

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...

3. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

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;...

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

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...

5. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

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>...

6. Shell Programming and Scripting

Shell Command to compare two xml lines while ignoring xml tags

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...

7. Shell Programming and Scripting

How to add Xml tags to an existing xml using shell or awk?

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>...

8. Shell Programming and Scripting

From sql Insert Query to XML format

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',...

9. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

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...

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

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...

LEARN ABOUT DEBIAN

occi-compute

OPENNEBULA(1)							   User Commands						     OPENNEBULA(1)

NAME

       OpenNebula - OpenNebula occi-compute

SYNOPSIS

       occi-compute <COMMAND> [OPTIONS] [ARGUMENTS]

DESCRIPTION

       occi-compute - Manages compute resources

OPTIONS

       --help, -h

	      Show help

       --username <id>, -U <id>

	      The username of the user

       --password <key>, -P <key>

	      The password of the user

       --url <url>, -R <url>

	      Set url as the web service url to use

       --timeout <seconds>, -T <seconds>

	      Sets a timeout for the http connection

       --debug, -D

	      Enables verbosity

       --verbose

	      Show resources in verbose mode

COMMANDS

       create <occi xml file>

	      creates a new compute resource described by the provided <occi xml file>

       list

	      lists available compute resources

       show <compute id>

	      retrieves the OCCI XML representation of the compute resource identified by <compute id>

       update <occi xml file>

	      updates the representation of the compute resource represented by the provided <occi xml file>

       delete <compute id>

	      deletes the compute resource idenfitied by <compute id>

COPYRIGHT

       Copyright 2002-2012, OpenNebula Project Leads (OpenNebula.org)

       Licensed  under	the  Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
       obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0

OpenNebula 3.4.1						    April 2012							     OPENNEBULA(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

2. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Discussion started by: reptile

3. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Discussion started by: guif

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Discussion started by: huasheng8