[Dbix-class] select from dual

[Hartmaier Alexander]

Hi!

 

If you grep through the dbic sources you can see that dbic uses raw sql to do that, for example to the get last inserted id in Oracle:

 

my $sql = "SELECT " . $seq . ".currval FROM DUAL";

my ($id) = $self->_dbh->selectrow_array($sql);

 

@mst: how much performance impact does the use of ‘’ instead of “” have?

 

-Alex

 

  _____  

From: dbix-class-bounces at lists.rawmode.org [mailto:dbix-class-bounces at lists.rawmode.org] On Behalf Of mark davies
Sent: Tuesday, July 11, 2006 5:56 PM
To: dbix-class at lists.rawmode.org
Subject: [Dbix-class] select from dual

 

Hi,

I am new to dbix::class. I am using an oracle database and need to select from dual in order to initialise an environment. What is the correct way to select from dual using dbix::class?

Mark

*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060712/16c42c20/attachment-0001.htm