On Sun, May 30, 2010 at 1:33 AM, newbie01 perl <newbie01.p...@gmail.com>wrote:
> Hi, > > 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? > > Not sure about what you mean by column formatting?? are you asking about the DDL commands like CREATE TABLE etc. The DDL commands can be done in perl but normally this would be done in a one off script. check out this link http://www.pythian.com/news/wp-content/uploads/introduction-dbd-oracle.html Also, is there anyway to sort of "hide" the password somehow when using Perl > DBI? > > Yes you can use Oracle Wallet or server authentication cheers John Scoles > Any advise or feedback will be very much appreciated. > > Thanks in advance. > -- Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. Hear Sheeri speak or email eve...@pythian.com to meet with Pythian.