05-03-2005
What ORacle error codes are you getting? like ORA-xxxxx ?
7 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I print on an HP Laserjet 5si and HP 8000 Laserjet. We print reports in landscape and when the reports are printed the font size is too big and some of the report is cut off. Is there any other options that I could try to use to correct this. The printers are set up correctly. I just need to... (4 Replies)
Discussion started by: skammer
4 Replies
2. UNIX for Dummies Questions & Answers
I have been asked to upload a font file for barcodes (3of9.ttf) to a unix server so that users of Oracle Reports on Oracle 10g can pick up this font. Where should this file be placed? (0 Replies)
Discussion started by: Chantho
0 Replies
3. AIX
Hi,
There's a report the previous AIX admin used to do and I couldn't find it on the AIX /etc/security. I think this customized.
Last update report (sample):
USER NAME IN REAL LIFE DATE LAST CHANGED PASSWORD
---- ----------------- ... (3 Replies)
Discussion started by: itik
3 Replies
4. Shell Programming and Scripting
i have sql script (ex:a.sql) that generates 10 csv files
ex: a.csv
b.csv
c.csv .........
but donot want 10 separate csv files
i want a single csv files with 10 different tab that contains all data
is it possible from unix
:( (2 Replies)
Discussion started by: alokjyotibal
2 Replies
5. UNIX and Linux Applications
Hi,
We are planning for a report generation program in Linux.For that we are planning to use Oracle reports 6i on linux.
Could anybody please confirm if the Oracle 6i reports are compatible on Linux (0 Replies)
Discussion started by: Pavan Pusuluri
0 Replies
6. Red Hat
Hello,
I have this problem:
I have a domain which worked well until my ISP changed my ip. Since then my DNS is not working, and intodns.com reports still the old IP. The DNS remains the same.
I made changes in named.conf, in ifcfg-Auto_eth0, I flushed the cache but it;s the same thing.
What... (6 Replies)
Discussion started by: doe_ro
6 Replies
7. Shell Programming and Scripting
I want to create reports using rsyslog in linux,Can someone help me out here ? Report Format must be "Hostname" "Username" "Hostname logged from" "Date" "Time"
Regards,
Ahmed.
---------- Post updated at 05:24 PM ---------- Previous update was at 05:24 PM ----------
Linux,Shell Script (10 Replies)
Discussion started by: ahmed.vaghar
10 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)