[Dbix-class] select from dual

[Thomas Hartman]

DBIC doesn't have any vender specific (eg, oracle specific) code, does it?

Or does it?

Thomas.

2006/7/12, Hartmaier Alexander <Alexander.Hartmaier at t-systems.at>:
>
>
>
>
> 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.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
> _______________________________________________
> List:
> http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN:
> http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
> http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>
>