Re: Describe table

2004-07-12 Thread Sapet Frederic
On Thu, 8 Jul 2004 18:42:47 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > On Thu, Jul 08, 2004 at 10:48:35AM +0200, Sapet Frederic wrote: > > On Wed, 7 Jul 2004 18:29:18 +0100 > > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > > > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > >

(Fwd) DB2 and "Upgrade" Re: Describe table

2004-07-10 Thread Tim Bunce
y-To: [EMAIL PROTECTED] Organization: Skywarn - MoP Newsgroups: perl.dbi.users To: Tim Bunce <[EMAIL PROTECTED]> Subject: DB2 and "Upgrade" Re: Describe table Tim Bunce answered ... > > > Upgrade. to which the reply was > > and all the methods I needed work fine n

Re: Describe table

2004-07-08 Thread Tim Bunce
On Thu, Jul 08, 2004 at 10:48:35AM +0200, Sapet Frederic wrote: > On Wed, 7 Jul 2004 18:29:18 +0100 > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > > > I am using > > > > > Oracle 8.1.5 > > > > > DBI 1.42 > > > and $DBD::Oracle::V

Re: Describe table

2004-07-08 Thread Sapet Frederic
On Wed, 7 Jul 2004 18:29:18 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > > I am using > > > > Oracle 8.1.5 > > > > DBI 1.42 > > and $DBD::Oracle::VERSION = '1.06'; > > > column_info= (not implemented) ? > > I don't understand

Re: Describe table

2004-07-07 Thread Tim Bunce
On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > I am using > > > Oracle 8.1.5 > > > DBI 1.42 > and $DBD::Oracle::VERSION = '1.06'; > column_info= (not implemented) ? > I don't understand :0( Upgrade. Tim.

Re: Describe table

2004-07-07 Thread Sapet Frederic
> > I am using > > Oracle 8.1.5 > > DBI 1.42 and $DBD::Oracle::VERSION = '1.06'; I laucnh the script like this : >DBI_TRACE=2 column_info.pl my script looks like: #!/bin/perl -w use strict; use diagnostics; use warnings; use DBI; my $dbh = DBI->connect('dbi:Oracle:gpdvt', 'OSNP', 'pwd') or

Re: Describe table

2004-07-07 Thread Tim Bunce
On Tue, Jul 06, 2004 at 06:11:18PM +0200, Sapet Frederic wrote: > On Tue, 6 Jul 2004 16:07:28 +0100 > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > I think in some cases it's better to use > > > > $sth = $dbh->column_info(...) > > > > :) > I am using > Oracle 8.1.5 > DBI 1.42 DBD::Oracle ?

Re: Describe table

2004-07-06 Thread Sapet Frederic
On Tue, 6 Jul 2004 16:07:28 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > I think in some cases it's better to use > > $sth = $dbh->column_info(...) > > :) > > Tim. > hi I am using Oracle 8.1.5 DBI 1.42 I tried to use this method like this : $sth = $dbh->column_info( undef,'OSNP', '%

Re: Describe table

2004-07-06 Thread Tim Bunce
> > -Original Message- > From: PerlDiscuss - Perl Newsgroups and mailing lists > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 06, 2004 5:16 AM > To: [EMAIL PROTECTED] > Subject: Re: Describe table > > > Hi > > You cannot use the DESCRIBE statement as

RE: Describe table

2004-07-06 Thread Helck, Timothy
under consideration, then user_tab_columns won't show that table. Tim Helck -Original Message- From: PerlDiscuss - Perl Newsgroups and mailing lists [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 5:16 AM To: [EMAIL PROTECTED] Subject: Re: Describe table Hi You cannot use the DESCRIBE

Re: Describe table

2004-07-06 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi You cannot use the DESCRIBE statement as it is. Try it in the following way select * from sys.user_tab_columns where table_name = ''; Cheers Prabu Jimmy Jauhal wrote: > Hi All, > I am trying to execute a DESCRIBE table statement from my perl script that > connects to an oracle DB. For s

Re: Describe table

2004-05-13 Thread David N Murray
DESCRIBE is a SQLPLUS command, not a SQL statement. I'm looking at the Oracle SQL Reference (8.1.7) and DESCRIBE isn't listed. An alternative that works for me is select * from sys.user_tab_columns where table_name = order by column_id; HTH, Dave On May 13, Jimmy Jauhal scribed: > Hi All, > >