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 <h...@wsr.ac.at> 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 > | | | h...@wsr.ac.at | 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----- > >
