Re: Pro*C vs SQLPlus script??

From: Steve Harmon <harmon#m#_Stephen_M_at_msmail.aai.arco.com>
Date: 1996/09/10
Message-ID: <3235BF2B.6844_at_msmail.aai.arco.com>#1/1


Take a look at ORA-Perl. This product has allowed me to do some really fancy work in about the same time as SQL*Plus, is very maintainable, allows password hiding, code reuse, pattern recognition, text manipulation, ... In other words, all of the best features of PRO*C, sqlplus, AWK, grep, ... in one neat package. Steve

GT Cherer wrote:
>
> Dudes-
> Other than the obvious cases - complex manipulation, when'ing, etc -
> what criteria does one use to weigh short-n-swift Pro*C programs vs
> quick-n-simple SQLPlus unix scripts when the case is something like drop
> all keys, or create indexes, or a fairly trivial cursor???? you know,
> when the issue is not writing the code itself. What do you look at?? time,
> of course, but what and where do other issues play in the mix like
> security, maintainability, login/password hiding, etc??
>
> I am sure this question hits us all sometime, so what's yer 2-pennies
> worth on how you flipped the coin?? thanxabunch
Received on Tue Sep 10 1996 - 00:00:00 CEST

Original text of this message