Why use it : SELECT 1 FROM DUAL

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 2 Aug 2012 14:52:39 -0300
Message-ID: <CAJdDhaOp4iEgGLJR3sPJpEf1=z7DzWf-2=ztXprfmK7zokaYzA_at_mail.gmail.com>

Hello friends,
I am analyzing some sql statments and found out in all queries the developer added the following where clause plus others...

   and exists (select 1 from dual)

All queries has this code.

Is there any good reason to put it in the sql statment ? Does it improve performance ?

This is the first time I see it in SQL ?

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 02 2012 - 12:52:39 CDT