|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
sqlloader issue
Post 302191039 by gkalangi on Thursday 1st of May 2008 10:22:46 AM
05-01-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies
2. Shell Programming and Scripting
Hello there,
I'm writing a shellscript and it uses sqlloader, it works good coz load the data into the DB. But I'm runing the shell from a java program with Runtime(). It does execute the shell but the sqlloader doesn't seem to be working!!
Does anybody out there knows why?? (0 Replies)
Discussion started by: ying_dav
0 Replies
3. Programming
Hi ,
I have a dellimited .dat file and a sqlloader.
I want to call the sqlloader from a oracle stored procedure.
The procedure should return the result of sqlloader's execution. (3 Replies)
Discussion started by: Haque123
3 Replies
4. Shell Programming and Scripting
Hi all,
I am very new to shell scripting.I have the requirement like
one program is there, if it is running leave like that only and if it is stopped it has to be restart and once again keep watching and it is stopped we a have to restart once agian.I want a shell script for this.Please help me... (10 Replies)
Discussion started by: bhas85
10 Replies
5. Shell Programming and Scripting
Dear,
I must load a file in a table via sqlloader. I have also a column in this table which must contain the same value for all rows in this table. And this value is get from a shell script variable.
Can you give me a sort example on how to use a shell script variable as a paramter in a CTL... (1 Reply)
Discussion started by: yeclota
1 Replies
6. UNIX for Dummies Questions & Answers
In LINUX(CentOS, RedHat) is there a way to have the banner statement appear before the logon instead of after the logon? In UNIX and Windows the banner appears before a person actually logs on, what I'm seeing in LINUX is that it appears after the login(ftp, telnet, SSH).
Thanks (0 Replies)
Discussion started by: ejjones
0 Replies
7. Shell Programming and Scripting
Hello I am having a problem with a script. I try to run a store procedure from unix with sqlldr and shows me the following error.
begin
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "RNP.SP_ARCH_SALIDA", line 64
ORA-06512: at line 2
The sp... (1 Reply)
Discussion started by: Rodrih92
1 Replies
8. Programming
Hi ,
I have a data file in this format.
p1 p2 p3
10 0
10 0 1000
I am using a sqlloader script to load the data into the database table.There is a unique constraint on the columns p1 and p2.
So, sqlldr cannot load both the records. This eliminates duplicate records from being... (1 Reply)
Discussion started by: megha2525
1 Replies
9. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
10. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
LEARN ABOUT MOJAVE
datetime::locale::fa_af
DateTime::Locale::fa_AF(3) User Contributed Perl Documentation DateTime::Locale::fa_AF(3) NAME
DateTime::Locale::fa_AF SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'fa_AF' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Persian Afghanistan. DATA
This locale inherits from the DateTime::Locale::fa locale. It contains the following data. Days Wide (format) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Abbreviated (format) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Narrow (format) X X X X X X X Wide (stand-alone) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Abbreviated (stand-alone) 2 3 4 5 6 7 1 Narrow (stand-alone) X X X X X X X Months Wide (format) XXXXX XXXXXX XXXX XXXXX XX XXX XXXXX XXXX XXXXXX XXXXXX XXXXX XXXXX Abbreviated (format) XXXXX XXXXXX XXXX XXXXX XX XXX XXXXX XXXX XXXXXX XXXXXX XXXXX XXXXX Narrow (format) X X X X X X X X X X X X Wide (stand-alone) XXXXX XXXXXX XXXX XXXXX XX XXX XXXXX XXXX XXXXXX XXXXXX XXXXX XXXXX Abbreviated (stand-alone) XXXXX XXXXXX XXXX XXXXX XX XXX XXXXX XXXX XXXXXX XXXXXX XXXXX XXXXX Narrow (stand-alone) X X X X X X X X X X X X Quarters Wide (format) XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXXXX Abbreviated (format) XXXX XXXX XXXX XXXX Narrow (format) X X X X Wide (stand-alone) XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXXXX Abbreviated (stand-alone) XXXX XXXX XXXX XXXX Narrow (stand-alone) X X X X Eras Wide XXX XX XXXXX XXXXXX Abbreviated X.X. X. Narrow X X Date Formats Full 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXX -10 Long 2008-02-05T18:30:30 = 5 XXXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXXX -10 Medium 2008-02-05T18:30:30 = 2008/2/5 1995-12-22T09:05:02 = 1995/12/22 -0010-09-15T04:44:23 = -010/9/15 Short 2008-02-05T18:30:30 = 08/2/5 1995-12-22T09:05:02 = 95/12/22 -0010-09-15T04:44:23 = -10/9/15 Default 2008-02-05T18:30:30 = 5 XXXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXXX -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 (UTC) 1995-12-22T09:05:02 = 9:05:02 (UTC) -0010-09-15T04:44:23 = 4:44:23 (UTC) Long 2008-02-05T18:30:30 = 18:30:30 (UTC) 1995-12-22T09:05:02 = 9:05:02 (UTC) -0010-09-15T04:44:23 = 4:44:23 (UTC) Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 Datetime Formats Full 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008X XXXX 18:30:30 (UTC) 1995-12-22T09:05:02 = XXXX 22 XXXXX 1995X XXXX 9:05:02 (UTC) -0010-09-15T04:44:23 = XXXX 15 XXXXXX -10X XXXX 4:44:23 (UTC) Long 2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30 (UTC) 1995-12-22T09:05:02 = 22 XXXXX 1995X XXXX 9:05:02 (UTC) -0010-09-15T04:44:23 = 15 XXXXXX -10X XXXX 4:44:23 (UTC) Medium 2008-02-05T18:30:30 = 2008/2/5X XXXX 18:30:30 1995-12-22T09:05:02 = 1995/12/22X XXXX 9:05:02 -0010-09-15T04:44:23 = -010/9/15X XXXX 4:44:23 Short 2008-02-05T18:30:30 = 08/2/5X XXXX 18:30 1995-12-22T09:05:02 = 95/12/22X XXXX 9:05 -0010-09-15T04:44:23 = -10/9/15X XXXX 4:44 Default 2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30 1995-12-22T09:05:02 = 22 XXXXX 1995X XXXX 9:05:02 -0010-09-15T04:44:23 = 15 XXXXXX -10X XXXX 4:44:23 Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (EEE d) 2008-02-05T18:30:30 = XXXXXXX 5 1995-12-22T09:05:02 = XXXX 22 -0010-09-15T04:44:23 = XXXX 15 GGGGyyyyMMMMd (d MMMM y GGGG) 2008-02-05T18:30:30 = 5 XXXXXX 2008 XXXXXX 1995-12-22T09:05:02 = 22 XXXXX 1995 XXXXXX -0010-09-15T04:44:23 = 15 XXXXXX -10 XXX XX XXXXX HHmmZ (HH:mm (Z)) 2008-02-05T18:30:30 = 18:30 (+0000) 1995-12-22T09:05:02 = 09:05 (+0000) -0010-09-15T04:44:23 = 04:44 (+0000) 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 XXX XX XXX 1995-12-22T09:05:02 = 9:05 XXX XX XXX -0010-09-15T04:44:23 = 4:44 XXX XX XXX 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 XX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XX XXX 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 = XXXXXXX 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 = XXXXXX 1995-12-22T09:05:02 = XXXXX -0010-09-15T04:44:23 = XXXXXX MMMd (d LLL) 2008-02-05T18:30:30 = 5 XXXXXX 1995-12-22T09:05:02 = 22 XXXXX -0010-09-15T04:44:23 = 15 XXXXXX MMMEd (E d LLL) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 1995-12-22T09:05:02 = XXXX 22 XXXXX -0010-09-15T04:44:23 = XXXX 15 XXXXXX MMMMd (d LLLL) 2008-02-05T18:30:30 = 5 XXXXXX 1995-12-22T09:05:02 = 22 XXXXX -0010-09-15T04:44:23 = 15 XXXXXX MMMMEd (E d LLLL) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 1995-12-22T09:05:02 = XXXX 22 XXXXX -0010-09-15T04:44:23 = XXXX 15 XXXXXX mmss (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 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 (E yyyy/M/d) 2008-02-05T18:30:30 = XXXXXXX 2008/2/5 1995-12-22T09:05:02 = XXXX 1995/12/22 -0010-09-15T04:44:23 = XXXX -010/9/15 yMMM (MMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXX 1995 -0010-09-15T04:44:23 = XXXXXX -10 yMMMEd (E d MMM y) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXX -10 yMMMM (MMMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXX 1995 -0010-09-15T04:44:23 = XXXXXX -10 yQ (yyyy Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -010 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 XXXX 1995-12-22T09:05:02 = 1995 XXXX -0010-09-15T04:44:23 = -10 XXXX yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyM (yyyy/M) 2008-02-05T18:30:30 = 2008/2 1995-12-22T09:05:02 = 1995/12 -0010-09-15T04:44:23 = -010/9 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXX 1995 -0010-09-15T04:44:23 = XXXXXX -10 yyyyMMMMEEEEd (EEEE d MMMM y) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXX -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week XXXX 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.18.2 2017-10-06 DateTime::Locale::fa_AF(3)