Re: infoperl (wish list)

Chris Hermansen (clh@tfic.bc.ca) writes: > Some of you may have seen OraPerl (Oracle extensions > to Perl), and I have some designs on that, too... Keep hearing about it, could someone please send me some manual pages for oraperl, so I know what I'm missing ? And an indication of how difficult it is to add extensions in, if poss. ? > create a named pipe [ ... write select stuff down it, read > off it with awk and write the report in awk ... ] A fine idea (and it still works: thanks). Just wondering - 1. Why did you pipe into nawk, not perl ? 8^) 2. How do you get rid of the count(*) and similar column headings ? I figure that 2>/dev/null in bourne sh gets rid of "Database selected" and a lot of that kind of stuff, but if I try SELECT COUNT(*) " " FROM foo I just get a syntax error (idea is just to blank out the heading, of course). Am I missing something really obvious ? I ended up piping the output thru egrep -v 'count(*)|^$' to cut the headings and the blank lines. > Anyway, if anyone's getting anywhere with InformiPerl, let me know... Ditto. Are you out there, Larry ? (and ta for the original if you are !). -- Cheers - Tony. ____________________________________________________________________________ Who: Tony Heskett | DHL Systems Ltd, Kings House, How: theskett@lhr-sys.ssf-sys.dhl.com | Great West Road, Brentford, TW8 9HS Vox: (+44) 81 747 8330 x 363 | Fax: (+44) 81 747 0875