Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SELECT from DUAL??

SELECT from DUAL??

From: Joseph Ranseth <jransethNO_SPAM_at_hotmail.com>
Date: Wed, 17 Jan 2001 16:56:20 -0600
Message-ID: <wtp96.790$wb7.15596@news1.mts.net>

I have come across many instances where people use a select from dual to determine or assign a value to a local variable, for example:

SELECT sysdateinto l_date FROM dual

what is the benefit of this over using a standard assignment expression? ie: l_date := sysdate;

Just wondering....
thanks in advance.

JR Received on Wed Jan 17 2001 - 16:56:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US