Re: Some DBI question -

Hi Peter,

Yes, that is correct ... am referring to these commands ...

If I already have the .sql file that has all the formatting in them, is it
okay to just run @x.sql from the Perl DBI script ...

BTW, you mentioned some "template toolkit", never heard of those ... can you
elaborate on them or give a link reference that I can check

On Tue, Jun 1, 2010 at 10:28 PM, Peter J. Holzer <[email protected]> wrote:

> On 2010-05-30 17:33:39 +1200, newbie01 perl wrote:
> > Am trying out DBI for Oracle and just want to know if for example, I need
> to
> > include column formatting stuff etc., is it best to just put them into a
> > .sql file and then execute the .sql file instead of placing them in the
> Perl
> > DBI script?
>
> By "column formatting stuff" you mean commands like
> column foo format a20
> ?
>
> These are sqlplus commands, not sql commands, i.e., they are features of
> the query tool, not the database. Consequently, they are not available
> in perl. To format data in Perl, use Perl features, like printf,
> formats, various templating toolkits, etc.
>
>        hp
>
> --
>   _  | Peter J. Holzer    | Auf jedem Computer sollte der Satz Ludwigs II
> |_|_) | Sysadmin WSR       | eingeprägt stehen: "Ein ewig Rätsel will ich
> | |   | [email protected]      | bleiben, mir und andern."
> __/   | http://www.hjp.at/ |    -- Wolfram Heinrich in desd
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iD8DBQFMBODFMdFfQa64PCwRAjWnAJ9OWXWMfa786KB1XIEQeFQZKZe9AwCfSMOU
> RPGR6X8KB4QAKqUBZdx+FeI=
> =UW1N
> -----END PGP SIGNATURE-----
>
>