[Dbix-class] select from dual

Jess Robinson castaway at desert-island.demon.co.uk
Wed Jul 19 10:33:35 CEST 2006



On Mon, 17 Jul 2006, A. Pagaltzis wrote:

> * Jess Robinson <castaway at desert-island.demon.co.uk> [2006-07-17 00:30]:
> What did you need it for?

Basically, in Oracle, you canÿÿt say things like

     SELECT NOW();

because a SELECT without a `FROM` clause is a syntax error. So
instead it has this weird special-case single-row, single-column
table called `dual` that always exists, so you have to say things
like that like so:

     SELECT SYSDATE FROM dual;

Isnÿÿt Oracle cool?

Nope.. and I knew what it was, I meant which specific application..

Also, Aristotle, your email does weird things to my client.. what are you 
using?

Jess



More information about the Dbix-class mailing list