[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