Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Variable
On 28 Apr 2007 15:00:22 -0700, William Robertson
<williamr2019_at_googlemail.com> wrote:
>Just to confirm, are you saying his assignment at line 7 should have
>been
>
>strTblName := &1;
>
>i.e. the quotes in the original example were not needed?
I'm not sure who the block head is here,
but I don't understand why you can't grasp the original code read
strTblname := '&1', the OP just ran that code, was prompted for &1 and
had to enter TB_B4000 *without* quotes!
Your nitpicking at me is fully irrelevant, and either you need better
glasses, or more coffee, or all of those.
--Received on Sat Apr 28 2007 - 17:24:48 CDT