Re: PL/SQL question/puzzle

From: David Edwards /DP <ded_at_kps.se>
Date: 23 Apr 93 07:37:51 GMT
Message-ID: <1315_at_kps.se>

In article <1992Jul8.205544.5008_at_stortek.com> v045100_at_otis1.UUCP (Jennifer Farnham) writes:
>
>Now, i'm a wizzard at 2.3 but these 3.0
>have me wondering sometimes. Here's the
>problem:
>
>This works in Sql*Plus:
>
>select '#BETWEEN ' || '''' || :control.date1 ||
>'''' || ' and ' || '''' || :control.date2 || ''''
>into :control.long_field
>from dual

Why don't you say:

	:control.long_field := '#BETWEEN ' || '''' || to_char(:control.date1)
		|| '''' || ' and ' || '''' || to_char(:control.date2) || '''';

Forget about dual and forms2 thinking.

David Edwards

---

To know recursion, you must first know recursion. Received on Fri Apr 23 1993 - 09:37:51 CEST