Raj, get another cup of coffee, or whatever
your favorite wakeup beverage is. :)
It was 'sqlplus' and 'Perl'.
No Oracle Reports.
Jared
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/14/2003 07:29 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: {SPAM?} RE: Teradata baned from IOUG???
Well,
I see one reason ... (I am no expert in Oracle reports), but it seems more
maintainable to write in SQR than in reports (so they claim here). Plus
SQR can act asa glorified data loader when a bunch of processing needs to
be done on incoming raw data.
I wouldn't discount SQR right away, but after all it is almost glorified
COBOL (IMHO).
Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again
my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup
tables and breaks make life simpler as well. It has usable array interface
... for data processing. We have couple of SQR reports that run in about
4000 lines of code (don't ask me why)
My $0.01
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Friday, February 14, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
We looked at SQR in 94.
We didn't have need of controlling fonts and such, which I guess
SQR is good at.
The SQR rep could come up with no compelling reason to use SQR
rather than Perl, so simple ( as in not much procedural processing
needed ) reports were done in Sqlplus. Anything complex was done
in Perl.
We never regretted that decision.
Jared
*********************************************************************This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*********************************************************************1
