Re: Some DBI question -
[email protected] ("Peter J. Holzer")
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
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
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iD8DBQFMBODFMdFfQa64PCwRAjWnAJ9OWXWMfa786KB1XIEQeFQZKZe9AwCfSMOU RPGR6X8KB4QAKqUBZdx+FeI= =UW1N -----END PGP SIGNATURE-----