Re: SELECT ... FROM DUAL ?

>
> SELECT SUBSTR (vissuedt, 3, 3) INTO vmonth FROM dual;
>
> my question is: would not this be more efficient written as:
>
> vmonth := SUBSTR(vissuedt,3,3);
>
> PL/SQL code I have seen and wanted to change right away:
>
> SELECT USER INTO v_username FROM dual;
>
> SELECT TRUNC(SYSDATE) INTO v_today FROM DUAL;
>

As I know, you cannot use each function using the syntax

   x := function;

Therefore you must use sometimes

    select from dual.

Regards Nicolas Received on Fri Sep 17 1999 - 04:17:09 CDT