|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Xapture Plsql Error from Unix Shell cript
Post 302412521 by imipsita.rath on Monday 12th of April 2010 09:52:57 PM
04-12-2010
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Right now if I have a file that has the following information (with : as the delimiter)
name :address :phone number
I need to be able to do the following commands:
-n search for a name
-p search for a phone number
-l search for a last name starting with a particular
-c find an... (17 Replies)
Discussion started by: Generic
17 Replies
2. Programming
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies
3. Shell Programming and Scripting
what is the maximum length of a unix shell variable which can be can passed to plsql variable:( (1 Reply)
Discussion started by: alokjyotibal
1 Replies
4. Programming
I am running the following ealth checks on my server
there are two databases in my server . MODEL1 and MODEL2
i connect with the first database as
sqlplus model1/password
Then i exceute a query
select x from table (4 Replies)
Discussion started by: asalman.qazi
4 Replies
5. Programming
Hi All,
I have a requirement to mv a file in unix from plsql procedure.
for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL
but i am getting an error ""Process err :/bin/sh: mv Not Found""
kindly let me... (1 Reply)
Discussion started by: aryan_styles
1 Replies
6. Shell Programming and Scripting
Hi all,
I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output.
I tried useing $variable_name, but it doesn't work.
Any kind of help is appreciated.
Thanks in advance. (3 Replies)
Discussion started by: bankimmehta
3 Replies
7. Shell Programming and Scripting
Hi,
I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database.
On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered... (7 Replies)
Discussion started by: hemant.bs11
7 Replies
8. Shell Programming and Scripting
I am working in production support in an leading bank and more of my job is more in oracle/plsql. I am learning unix shell scripting and have started development in the same.I would like to know regarding the scope of these two in the industry.Also would like to know about other scripting... (2 Replies)
Discussion started by: jesthomas
2 Replies
9. Shell Programming and Scripting
I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell... (4 Replies)
Discussion started by: rspnf
4 Replies
10. UNIX for Dummies Questions & Answers
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies
LEARN ABOUT CENTOS
datetime::locale::om_ke
DateTime::Locale::om_KE(3) User Contributed Perl Documentation DateTime::Locale::om_KE(3) NAME
DateTime::Locale::om_KE SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'om_KE' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Oromo Kenya. DATA
This locale inherits from the DateTime::Locale::om locale. It contains the following data. Days Wide (format) Wiixata Qibxata Roobii Kamiisa Jimaata Sanbata Dilbata Abbreviated (format) Wix Qib Rob Kam Jim San Dil Narrow (format) M T W T F S S Wide (stand-alone) Wiixata Qibxata Roobii Kamiisa Jimaata Sanbata Dilbata Abbreviated (stand-alone) Wix Qib Rob Kam Jim San Dil Narrow (stand-alone) M T W T F S S Months Wide (format) Amajjii Guraandhala Bitooteessa Elba Caamsa Waxabajjii Adooleessa Hagayya Fuulbana Onkololeessa Sadaasa Muddee Abbreviated (format) Ama Gur Bit Elb Cam Wax Ado Hag Ful Onk Sad Mud Narrow (format) J F M A M J J A S O N D Wide (stand-alone) Amajjii Guraandhala Bitooteessa Elba Caamsa Waxabajjii Adooleessa Hagayya Fuulbana Onkololeessa Sadaasa Muddee Abbreviated (stand-alone) Ama Gur Bit Elb Cam Wax Ado Hag Ful Onk Sad Mud Narrow (stand-alone) J F M A M J J A S O N D Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated KD KB Narrow KD KB Date Formats Full 2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008 1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995 -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10 Long 2008-02-05T18:30:30 = 05 Guraandhala 2008 1995-12-22T09:05:02 = 22 Muddee 1995 -0010-09-15T04:44:23 = 15 Fuulbana -10 Medium 2008-02-05T18:30:30 = 05-Gur-2008 1995-12-22T09:05:02 = 22-Mud-1995 -0010-09-15T04:44:23 = 15-Ful--10 Short 2008-02-05T18:30:30 = 05/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = 05-Gur-2008 1995-12-22T09:05:02 = 22-Mud-1995 -0010-09-15T04:44:23 = 15-Ful--10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 WB UTC 1995-12-22T09:05:02 = 9:05:02 WD UTC -0010-09-15T04:44:23 = 4:44:23 WD UTC Long 2008-02-05T18:30:30 = 6:30:30 WB UTC 1995-12-22T09:05:02 = 9:05:02 WD UTC -0010-09-15T04:44:23 = 4:44:23 WD UTC Medium 2008-02-05T18:30:30 = 6:30:30 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD Short 2008-02-05T18:30:30 = 6:30 WB 1995-12-22T09:05:02 = 9:05 WD -0010-09-15T04:44:23 = 4:44 WD Default 2008-02-05T18:30:30 = 6:30:30 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD Datetime Formats Full 2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008 6:30:30 WB UTC 1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995 9:05:02 WD UTC -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10 4:44:23 WD UTC Long 2008-02-05T18:30:30 = 05 Guraandhala 2008 6:30:30 WB UTC 1995-12-22T09:05:02 = 22 Muddee 1995 9:05:02 WD UTC -0010-09-15T04:44:23 = 15 Fuulbana -10 4:44:23 WD UTC Medium 2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB 1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD Short 2008-02-05T18:30:30 = 05/02/08 6:30 WB 1995-12-22T09:05:02 = 22/12/95 9:05 WD -0010-09-15T04:44:23 = 15/09/-10 4:44 WD Default 2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB 1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 Qib 1995-12-22T09:05:02 = 22 Jim -0010-09-15T04:44:23 = 15 San Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 WB 1995-12-22T09:05:02 = 9:05 WD -0010-09-15T04:44:23 = 4:44 WD 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 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 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 = Qib, 2-5 1995-12-22T09:05:02 = Jim, 12-22 -0010-09-15T04:44:23 = San, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = Gur 1995-12-22T09:05:02 = Mud -0010-09-15T04:44:23 = Ful MMMd (MMM d) 2008-02-05T18:30:30 = Gur 5 1995-12-22T09:05:02 = Mud 22 -0010-09-15T04:44:23 = Ful 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Qib Gur 5 1995-12-22T09:05:02 = Jim Mud 22 -0010-09-15T04:44:23 = San Ful 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = Guraandhala 5 1995-12-22T09:05:02 = Muddee 22 -0010-09-15T04:44:23 = Fuulbana 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 Guraandhala 1995-12-22T09:05:02 = 22 Muddee -0010-09-15T04:44:23 = 15 Fuulbana MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Qib Guraandhala 5 1995-12-22T09:05:02 = Jim Muddee 22 -0010-09-15T04:44:23 = San Fuulbana 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 (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = Qib, 2008-2-5 1995-12-22T09:05:02 = Jim, 1995-12-22 -0010-09-15T04:44:23 = San, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Gur 1995-12-22T09:05:02 = 1995 Mud -0010-09-15T04:44:23 = -10 Ful yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Qib, 2008 Gur 5 1995-12-22T09:05:02 = Jim, 1995 Mud 22 -0010-09-15T04:44:23 = San, -10 Ful 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Guraandhala 1995-12-22T09:05:02 = 1995 Muddee -0010-09-15T04:44:23 = -10 Fuulbana yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = Guraandhala 2008 1995-12-22T09:05:02 = Muddee 1995 -0010-09-15T04:44:23 = Fuulbana -10 Miscellaneous Prefers 24 hour time? No Local first day of the week Sanbata 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.3 2014-06-10 DateTime::Locale::om_KE(3)