|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
any possible solution on sql calling scripts
Post 302146575 by Cameron on Wednesday 21st of November 2007 07:58:40 AM
11-21-2007
It's highly likely that you didn't search the forums for 'sqlplus' .
Whilst this may not answer all your questions, it might put you on the right path.
How to check sqlplus command is successfull or not in HP UX?
Trying to perform SQL in the way you've shown is really hard to manage over time.
In future, make use of the search feature in these forums.
You questions is more than likely to have been asked before in the past.
Cheers,
Cameron
Whilst this may not answer all your questions, it might put you on the right path.
How to check sqlplus command is successfull or not in HP UX?
Trying to perform SQL in the way you've shown is really hard to manage over time.
In future, make use of the search feature in these forums.
You questions is more than likely to have been asked before in the past.
Cheers,
Cameron
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies
2. 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
3. Shell Programming and Scripting
Hi All ,
I have created .sql script in unix.this script contains 4 sql queries. Now I want to craete .sh file based on .sql script. So please let me know the steps to craete .sh file
Thank you. (1 Reply)
Discussion started by: user71408
1 Replies
4. Shell Programming and Scripting
What is the difference between calling the sub scripts of below two line.
/home/scripts/devdb.sh
. /home/scripts/devdb.sh
sh /home/scripts/devdb.sh
We are using the suse 2.0 version (4 Replies)
Discussion started by: kingganesh04
4 Replies
5. Shell Programming and Scripting
Hi,
I have written a some six scripts to move large files and re-size them. This has been done step by step, taking backup, creating the new files, merging the files, removing the temporary files created.
Since these files are around 500 MB, each step takes somewhere between 1 to 5 mins.
... (1 Reply)
Discussion started by: baanprog
1 Replies
6. Shell Programming and Scripting
I need to call 3 different shell scripts from 2 different scripts, one is a perl script and other is Shell script.
In Case -1 :
The perl script is myperlscript.pl
and the name of three shell scripts which need to be called from the perl script are a1.sh, a2.sh and a3.sh. Each shell script... (1 Reply)
Discussion started by: siba.s.nayak
1 Replies
7. 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
8. 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
9. Shell Programming and Scripting
Dear all,
I am working on script which call other shell scripts in a loop but problem is from second script am not able to come out.
Here is the snippet:-
#!/bin/bash
HSFILE=/root/Test/Components.txt
LOGFile=/opt/domain/AdminDomain/application/logs... (3 Replies)
Discussion started by: sharsour
3 Replies
10. Shell Programming and Scripting
I have a requirement of bash shell script calling SQL*Plus script.
Shell Script
sqlplus <user>/<pwd> @sqlscript1 parameters
sqlplus <user>/<pwd> @sqlscript2 parameters
Now I need the values generated by sqlscript1 in sqlscript2. But it is more like a huge dataset in a table and not one... (7 Replies)
Discussion started by: uuuunnnn
7 Replies
LEARN ABOUT OSX
datetime::locale::ur
DateTime::Locale::ur(3) User Contributed Perl Documentation DateTime::Locale::ur(3) NAME
DateTime::Locale::ur SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ur' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Urdu. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) XXX XXXX XXX XXXXXX XXXX XXXX XXXXX Abbreviated (format) XXX XXXX XXX XXXXXX XXXX XXXX XXXXX Narrow (format) X X X X X X X Wide (stand-alone) XXX XXXX XXX XXXXXX XXXX XXXX XXXXX Abbreviated (stand-alone) 2 3 4 5 6 7 1 Narrow (stand-alone) X X X X X X X Months Wide (format) XXXXX XXXXX XXX X XXXXX XX XXX XXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Abbreviated (format) XXXXX XXXXX XXX X XXXXX XX XXX XXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Narrow (format) X X X X X X X X X X X X Wide (stand-alone) XXXXX XXXXX XXX X XXXXX XX XXX XXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Abbreviated (stand-alone) 1 2 3 4 5 6 7 8 9 10 11 12 Narrow (stand-alone) X X X X X X X X X X X X Quarters Wide (format) XXXX XX XXXX XXXXX XX XXXX XXXXX XX XXXX XXXXX XX XXXX Abbreviated (format) 1XX XXXX 2XX XXXX 3XX XXXX 4XX XXXX Narrow (format) 1 2 3 4 Wide (stand-alone) XXXX XX XXXX XXXXX XX XXXX XXXXX XX XXXX XXXXX XX XXXX Abbreviated (stand-alone) 1XX XXXX 2XX XXXX 3XX XXXX 4XX XXXX Narrow (stand-alone) 1 2 3 4 Eras Wide XXX XXXX XXXXX XX Abbreviated X X XXXXX XX Narrow X X XXXXX XX Date Formats Full 2008-02-05T18:30:30 = XXXX, 5, XXXXX 2008 1995-12-22T09:05:02 = XXXX, 22, XXXXX 1995 -0010-09-15T04:44:23 = XXXX, 15, XXXXX -10 Long 2008-02-05T18:30:30 = 5, XXXXX 2008 1995-12-22T09:05:02 = 22, XXXXX 1995 -0010-09-15T04:44:23 = 15, XXXXX -10 Medium 2008-02-05T18:30:30 = 5, XXXXX 2008 1995-12-22T09:05:02 = 22, XXXXX 1995 -0010-09-15T04:44:23 = 15, XXXXX -10 Short 2008-02-05T18:30:30 = 5/2/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/9/-10 Default 2008-02-05T18:30:30 = 5, XXXXX 2008 1995-12-22T09:05:02 = 22, XXXXX 1995 -0010-09-15T04:44:23 = 15, XXXXX -10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 XXX XXXXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXXXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX UTC Long 2008-02-05T18:30:30 = 6:30:30 XXX XXXXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXXXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX UTC Medium 2008-02-05T18:30:30 = 6:30:30 XXX XXXXX 1995-12-22T09:05:02 = 9:05:02 XXX XXXXX -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX Short 2008-02-05T18:30:30 = 6:30 XXX XXXXX 1995-12-22T09:05:02 = 9:05 XXX XXXXX -0010-09-15T04:44:23 = 4:44 XXX XXXXX Default 2008-02-05T18:30:30 = 6:30:30 XXX XXXXX 1995-12-22T09:05:02 = 9:05:02 XXX XXXXX -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX Datetime Formats Full 2008-02-05T18:30:30 = XXXX, 5, XXXXX 2008 6:30:30 XXX XXXXX UTC 1995-12-22T09:05:02 = XXXX, 22, XXXXX 1995 9:05:02 XXX XXXXX UTC -0010-09-15T04:44:23 = XXXX, 15, XXXXX -10 4:44:23 XXX XXXXX UTC Long 2008-02-05T18:30:30 = 5, XXXXX 2008 6:30:30 XXX XXXXX UTC 1995-12-22T09:05:02 = 22, XXXXX 1995 9:05:02 XXX XXXXX UTC -0010-09-15T04:44:23 = 15, XXXXX -10 4:44:23 XXX XXXXX UTC Medium 2008-02-05T18:30:30 = 5, XXXXX 2008 6:30:30 XXX XXXXX 1995-12-22T09:05:02 = 22, XXXXX 1995 9:05:02 XXX XXXXX -0010-09-15T04:44:23 = 15, XXXXX -10 4:44:23 XXX XXXXX Short 2008-02-05T18:30:30 = 5/2/08 6:30 XXX XXXXX 1995-12-22T09:05:02 = 22/12/95 9:05 XXX XXXXX -0010-09-15T04:44:23 = 15/9/-10 4:44 XXX XXXXX Default 2008-02-05T18:30:30 = 5, XXXXX 2008 6:30:30 XXX XXXXX 1995-12-22T09:05:02 = 22, XXXXX 1995 9:05:02 XXX XXXXX -0010-09-15T04:44:23 = 15, XXXXX -10 4:44:23 XXX XXXXX Available Formats d (X) 2008-02-05T18:30:30 = X 1995-12-22T09:05:02 = X -0010-09-15T04:44:23 = X EEEd (d EEE) 2008-02-05T18:30:30 = 5 XXXX 1995-12-22T09:05:02 = 22 XXXX -0010-09-15T04:44:23 = 15 XXXX Hm (HH:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 XXX XXXXX 1995-12-22T09:05:02 = 9:05 XXX XXXXX -0010-09-15T04:44:23 = 4:44 XXX XXXXX Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 XXX XXXXX 1995-12-22T09:05:02 = 9:05:02 XXX XXXXX -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX M (LL) 2008-02-05T18:30:30 = 02 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 09 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = XXXX, 2-5 1995-12-22T09:05:02 = XXXX, 12-22 -0010-09-15T04:44:23 = XXXX, 9-15 MMM (LLL) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 MMMd (MMM d) 2008-02-05T18:30:30 = XXXXX 5 1995-12-22T09:05:02 = XXXXX 22 -0010-09-15T04:44:23 = XXXXX 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = XXXX XXXXX 5 1995-12-22T09:05:02 = XXXX XXXXX 22 -0010-09-15T04:44:23 = XXXX XXXXX 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = XXXXX 5 1995-12-22T09:05:02 = XXXXX 22 -0010-09-15T04:44:23 = XXXXX 15 MMMMEd (E MMMM d) 2008-02-05T18:30:30 = XXXX XXXXX 5 1995-12-22T09:05:02 = XXXX XXXXX 22 -0010-09-15T04:44:23 = XXXX XXXXX 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (yyyy-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -010-9 yMEd (EEE, yyyy-d-M) 2008-02-05T18:30:30 = XXXX, 2008-5-2 1995-12-22T09:05:02 = XXXX, 1995-22-12 -0010-09-15T04:44:23 = XXXX, -010-15-9 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 XXXXX 1995-12-22T09:05:02 = 1995 XXXXX -0010-09-15T04:44:23 = -10 XXXXX yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = XXXX, 2008 XXXXX 5 1995-12-22T09:05:02 = XXXX, 1995 XXXXX 22 -0010-09-15T04:44:23 = XXXX, -10 XXXXX 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 XXXXX 1995-12-22T09:05:02 = 1995 XXXXX -0010-09-15T04:44:23 = -10 XXXXX yQ (Q yyyy) 2008-02-05T18:30:30 = 1 2008 1995-12-22T09:05:02 = 4 1995 -0010-09-15T04:44:23 = 3 -010 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 1XX XXXX 1995-12-22T09:05:02 = 1995 4XX XXXX -0010-09-15T04:44:23 = -10 3XX XXXX yyQ (yy Q) 2008-02-05T18:30:30 = 08 1 1995-12-22T09:05:02 = 95 4 -0010-09-15T04:44:23 = -10 3 Miscellaneous Prefers 24 hour time? No Local first day of the week XXX SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.2 2013-08-25 DateTime::Locale::ur(3)