"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:sn0o31hvilna0q2f947mbhimjacohbpaqc_at_4ax.com...
> On Sat, 19 Mar 2005 09:54:15 GMT, "Randy Harris" <randy_at_SpamFree.com>
> wrote:
>
> >
> >I'm just starting out with PL/SQL and would appreciate some advice. I've
> >written a simple procedure to write some data out to a file. I would
like
> >the file to have fixed width fields, seperated by pipes. The data gets
out
> >to the file OK, but not fixed width. What can I do to correct that?
Also,
> >please point out my rookie mistakes.
>
> If the original columns are varchar2 you would need to use RPAD
> everywhere to properly lineup your data. As you already have a
> separator, I'm not sure what compelling reason there is (other than to
> waste disk space), to do this.
>
> Your sql statement is of course horrible. It is not formatted at all,
> and it uses hardcoded literals all over the place. Procedures and
> cursors have parameters. In your case you would probably create 1000
> almost identical procedures, except for the hardcoded literals, and
> choke your CPU to death by doing so.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Sybrand, if those same literals will "ALWAYS" be used to select the data how
can I make the SQL more efficient?
Received on Sat Mar 19 2005 - 10:39:38 CST
