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:
> > > >
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
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
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
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.
> > 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
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 ?
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', '%
>
> -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
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
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
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,
>
>
12 matches
Mail list logo