Re: non-DBA FAQ (first cut)

In <AABWSahGx0_at_sg2.kbv> oracle_at_vostok.marine.su (Alex Novicky) writes:

>dtb_at_otto (David Bath) in article <dtb.730734663@otto> said:
 

>>> 14. RPT/RPF
>>> Ancient tool with ugly syntax still used by some for
>>> batch updates where they want portable code and do not
>>> want to embed SQL in a language like C, especially
>>> before PL/SQL extensions to SQL*Plus became available.
 

>Let me disagree because I believe RPT/RPF is very simple in use
>and powerful enough to meet all our (and lots of other people) designer's
>requirements. It's easier to write text file with well readable and
>editable SQL and RPT/RPF statments rather than edit SQL*ReportWriter data
>through complicated menu-driven interface. (Maybe it seems to someone realy
>ancient but I sometimes like to quikly edit in the same way SQL*Forms *.inp
>files instead of using IAD tool.)
 

>And we use RPT/RPF tool not only 'for batch updates' but for just writing
>reports. All our end users have only that kind of data output.
>And they like it !
 

>I hope Oracle will support excellent RPT/RPF tool in current and further
>versions and my opinion will contribute in 'is or is not this Oracle
>product obsolete' argument.
 

>Buy, Alex.
>--
>======================================================================
>Alex Novicky | Vladivostok | Russia | voice phone (Russia)(4232)266996
>====================================+ e-mail : oracle_at_vostok.marine.su
> +=================================

Ditto, we use it extensively for our reports. Reportwriter still cannot handle complex expressions so until then rpf/rpt is the way. Due to the inefficiency of RPT weve taken to writing Pro*C that generates RPF output.

+=======================================================================+
|          Mark Hayes                                                   |
|  ,-_|\   Corporate Systems               Internet: mah_at_DIALix.oz.au   |
| /     \  83 Mill Point Road              Phone: +61 9 264 1616        |
| *_,-._/  South Perth  WA 6151            Fax:   +61 9 474 2553        |
|      v                                                                |
+=======================================================================+
          Theres a mountain of code to my next ski trip ....