Dick, But is was a fun tool to program in! It was so string in that it (at the time) was the only tool that could interface with OS files, Oracle, and produce output at the same time. We bought it instead of RPT and RPF. I almost had a heart-attack when Oracle classes showed us those POC and said "this is our batch tool". I started searching immediately as we wanted to throw away Cobol. SQR was the only choice. (This is back about 10 years ago).
Have you tried the "Reverse Hebrew Wrap" printing option? :) When things got slow, I'd bring that baby up for a few laughs. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Thursday, September 12, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Tom, I regret to say that SQR is still running around. SOD awful piece of crap that should have dies along with RPT and RPF. PeopleSoft makes a lot of use of it & it is a REAL performance boat anchor. Dick Goulet ____________________Reply Separator____________________ Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 9/12/2002 11:03 AM Raj, I know SQR. Bought it when it was being peddled by Sql Solutions. Great tool! Somehow, it never got marketed correctly. I had heard that at one point, Oracle "almost" bought it, and was going to position it as one of its products. But that boat has sailed. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Thursday, September 12, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Wait till you see some of the SQL that we run ... it is dynamic sql used within SQR (a reporting tool). Compared to that, this is production quality. 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----- <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, September 12, 2002 12:38 PM To: Multiple recipients of list ORACLE-L here's a decode that should *NEVER* be put into production! :) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: Decode</TITLE> <META content="MSHTML 5.50.4912.300" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=140375317-12092002><FONT face=Arial color=#0000ff size=2>Raj,</FONT></SPAN></DIV> <DIV><SPAN class=140375317-12092002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=140375317-12092002><FONT face=Arial color=#0000ff size=2>I know SQR. Bought it when it was being peddled by Sql Solutions. Great tool! Somehow, it never got marketed correctly. I had heard that at one point, Oracle "almost" bought it, and was going to position it as one of its products. But that boat has sailed.</FONT></SPAN></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Tom Mercadante</FONT> <BR><FONT face=Arial size=2>Oracle Certified Professional</FONT> </DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Thursday, September 12, 2002 2:08 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Decode<BR><BR></FONT></DIV> <P><FONT size=2>Wait till you see some of the SQL that we run ... it is dynamic sql used within SQR (a reporting tool). Compared to that, this is production quality.</FONT></P> <P><FONT size=2>Raj</FONT> <BR><FONT size=2>______________________________________________________</FONT> <BR><FONT size=2>Rajendra Jamadagni MIS, ESPN Inc.</FONT> <BR><FONT size=2>Rajendra dot Jamadagni at ESPN dot com</FONT> <BR><FONT size=2>Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. </FONT><BR><FONT size=2>QOTD: Any clod can have facts, but having an opinion is an art!</FONT> </P><BR> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Mercadante, Thomas F [<A href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]< /F ONT> <BR><FONT size=2>Sent: Thursday, September 12, 2002 12:38 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: Decode</FONT> </P><BR> <P><FONT size=2>here's a decode that should *NEVER* be put into production! :)</FONT> </P></BLOCKQUOTE></BODY></HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).