You may be able to use the explain plan functionality in Oracle to
obtain the tables participating in a SELECT statement.
Steve
On Wed, 2008-05-07 at 12:48 -0700, Jonathan Leffler wrote:
> On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph <[EMAIL PROTECTED]> wrote:
>
> > To answer you question, for a
On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph <[EMAIL PROTECTED]> wrote:
> To answer you question, for an Oracle environment I would like
> $sth->{TABLENAME} to contain a list.
>
> my $tablename = $sth->{TABLENAME} ->[0] = First table
> $tablename $sth->{TABLENAME} ->[1] = Second table
>
> The $
I will have to break apart the SQL statement with a regex and store it that
way.
Thanks for the input.
Joseph Lamb
- Forwarded Message
From: Jonathan Leffler <[EMAIL PROTECTED]>
To: Lamb Joseph <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org
Sent: Wednesday, May 7, 2008 12:22:06 PM
Subje
To answer you question, for an Oracle environment I would like
$sth->{TABLENAME} to contain a list.
my $tablename = $sth->{TABLENAME} ->[0] = First table
$tablename $sth->{TABLENAME} ->[1] = Second table
The $tablename value will be schema.tablename format.
For example:
schema.narf
schem
On Wed, May 7, 2008 at 10:51 AM, Lamb Joseph <[EMAIL PROTECTED]> wrote:
> I am creating a simple tool that will query one table and retrieve the
> data. Then this tool will turn the data into insert statements.
>
> I was wondering if there was a way to retrieve the table name from the
> statement
Hmmm, and what do you think $sth->{TABLENAME} should contain after
executing the following SQL?
SELECT t1.foo,t2.bar FROM narf t1, zord t2 WHERE t1.ikes=t2.blurb
Alexander
On 07.05.2008 19:51, Lamb Joseph wrote:
I am creating a simple tool that will query one table and retrieve the data.
The
I am creating a simple tool that will query one table and retrieve the data.
Then this tool will turn the data into insert statements.
I was wondering if there was a way to retrieve the table name from the
statement handle?
Similar to print "SQL statement contains $sth->{NUM_OF_FIELDS} columns\
Thanks Martin and Tim you pointed me in the right direction and
DBD::ODBC now works on my Mac OS X Leopard machine.
For anyone having trouble getting it to work, this is what I did.
Rebuild DBI v1.604 - I did this with a cpan force install
export LD_LIBRARY_PATH=/usr/local/iODBC/lib
cd DBD-ODB
On 2008-05-05 10:46:05 -0700, pgodfrin wrote:
> My install of Oracle, for reasons unknown to me, had this file set to
> rwxr-x--- which doesn't work for 'others'.
In recent versions of Oracle, by default the programs and libraries
installed with a server installation are only usable by the DBA gro