07-07-2006
Arrays in unix
I have a Main shell script file. In that the below lines(7) is spooled in Oracle & written to a file say temp.out
INSTANCE_N
----------
undefined
PROACT1
REPCAT1
PROACT2
REPCAT2
I want to ignore the first 3 lines & put the rest 4 lines PROACT1..REPCAT2 into the arrays. So that i can use those values in my program. How to do that. My environment is Sunsolaris, Oracle.
Appreciate your reply.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all
Iam trying to send an array to oracle procedure from unix. Iam writing a program in K Shell to pass this array to oracle. Is it possible. Please advice
thanks
Krishna (7 Replies)
Discussion started by: krishnasai
7 Replies
2. UNIX for Dummies Questions & Answers
Is it possible to say..
myArr=34
myArr=15
? (11 Replies)
Discussion started by: yongho
11 Replies
3. Shell Programming and Scripting
Hi all...
Im looking to pass the contents of a simple file to Oracle so that it can be stored in a database table.
The best way i can think of to avoid overhead is to loop through the contents of the file and store the data in a bash array. then the array can be passed to SQL Plus where... (4 Replies)
Discussion started by: satnamx
4 Replies
4. Web Development
PHP question...
I have an SQL query that's pulled back user IDs as a set of columns. Rather than IDs, I want to use their names.
So I have an array of columns $col with values 1,7,3,12 etc and I've got an array $person with values "Fred", "Bert", "Tom" etc
So what I want to do is display the... (3 Replies)
Discussion started by: JerryHone
3 Replies
5. Shell Programming and Scripting
hi everybody
can anyone help me with usage of 2 dimensional arrays in unix. please provide a suitable example for accessing individual elements as well as all elements.
Thanks (2 Replies)
Discussion started by: jpriyank
2 Replies
6. UNIX for Dummies Questions & Answers
Hi there,
I have a small piece of code
i=1
Number=10
while
do
echo "$i"
Check=`cmd to give to me file name with path
i=`expr ${i} + 1`
done
when i do in a loop echo "$Check"---------Unable to display, the values.
... (5 Replies)
Discussion started by: Naveen_5960
5 Replies
7. Shell Programming and Scripting
Say I have ./param HEY
What would I do if I wanted to store each character into an array?
Example.
ARRAY1="H"
ARRAY1="E"
ARRAY1="Y"
thank you! (5 Replies)
Discussion started by: puttster
5 Replies
8. Programming
if i declare both but don't input any variables what values will the int array and file pointer array have on default, and if i want to reset any of the elements of both arrays to default, should i just set it to 0 or NULL or what? (1 Reply)
Discussion started by: omega666
1 Replies
9. UNIX for Dummies Questions & Answers
hi all,
is there any method to declare each line of a text file to array variable.
my text file is:
123
222
333
so,
a=123
a=222
a=333
can anyone help me out pls...
thanks in advance,
Arun Manas:b: (4 Replies)
Discussion started by: arunmanas
4 Replies
10. UNIX for Advanced & Expert Users
Hi,
Can anyone please guide me to pass the values for an array during runtime and use it.
I am using Linux OS.
what I am trying to do is, i am trying to pass the output of the ls <source folder> command to a array and copy the list of files in the array to a different (Destination) folder.... (7 Replies)
Discussion started by: shyamshankarj
7 Replies
LEARN ABOUT DEBIAN
convert::nls_date_format
Convert::NLS_DATE_FORMAT(3pm) User Contributed Perl Documentation Convert::NLS_DATE_FORMAT(3pm)
NAME
Convert::NLS_DATE_FORMAT - Convert Oracle NLS_DATE_FORMAT <-> strftime Format Strings
SYNOPSIS
use Convert::NLS_DATE_FORMAT qw(oracle2posix posix2oracle);
my $strptime = oracle2posix($NLS_DATE_FORMAT);
$NLS_DATE_FORMAT = posix2oracle($strftime);
DESCRIPTION
Convert Oracle's NLS_DATE_FORMAT string into a strptime format string, or the reverse.
Functions
oracle2posix
Takes an Oracle NLS_DATE_FORMAT string and converts it into formatting string compatible with "strftime" or "strptime".
my $format = oracle2posix('YYYY-MM-DD HH24:MI:SS'); # '%Y-%m-%d %H:%M:%S'
Character sequences that should not be translated may be enclosed within double quotes, as specified in the Oracle documentation.
my $format = oracle2posix('YYYY-MM-DD"T"HH24:MI:SS'); # '%Y-%m-%dT%H:%M:%S'
posix2oracle
Takes a "strftime" or "strptime" formatting string and converts it into an Oracle NLS_DATE_FORMAT string. It is possible to create
strings which Oracle will not accept as valid NLS_DATE_FORMAT strings.
my $format = posix2oracle('%Y-%m-%d %H:%M:%S'); # 'YYYY-MM-DD HH24:MI:SS'
EXPORT
None by default. "oracle2posix" and "posix2oracle" when asked.
SEE ALSO
DateTime::Format::Oracle.
AUTHOR
Nathan Gray, <kolibrie@cpan.org>
COPYRIGHT AND LICENSE
Copyright (C) 2005, 2006, 2011, 2012 Nathan Gray
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.4 or,
at your option, any later version of Perl 5 you may have available.
perl v5.14.2 2012-01-18 Convert::NLS_DATE_FORMAT(3pm)