in reply to Re: Re: DBD::SQLite
in thread Error querying DBD::SQLite

Oracle has a special "virtual" table called dual, which is commonly used to select from when all you want to do is run a function, for example:

select sqrt(25) + power(2,3) - round(4.645432, 1) from dual;
The SQL in the example, select 1 from dual, is often used to ping the database. It essentially does nothing at all except talk to the database and ask it to return the value 1. I don't think this is standard SQL stuff, but rather an Oracle-specific extension.