Re: Some DBI question -

On Sun, May 30, 2010 at 1:33 AM, newbie01 perl <newbie01.perl@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 events@pythian.com to meet with Pythian.

• Some DBI question - by newbie01 perl
• Re: Some DBI question - by John Scoles
• Re: Some DBI question - by Chas. Owens