Re: query

From: magicwand <magicwand_at_gmx.at>
Date: Mon, 21 Jun 2010 12:14:37 -0700 (PDT)
Message-ID: <b6567824-433a-4a1f-b12c-246d1d0502bc_at_s9g2000yqd.googlegroups.com>

On Jun 21, 7:16 pm, stunaz <stu..._at_gmail.com> wrote:
> cant still see it
> On 21 juin, 12:46, Robert Klemme <shortcut..._at_googlemail.com> wrote:
>
>
>
> > On 21.06.2010 16:44, stunaz wrote:
>
> > > Hello,
>
> > > while writing this code
>
> > > EXECUTE IMMEDIATE ('ALTER TABLE MAILS_TEMPLATES ADD (SEND_ITEM
> > > VARCHAR2(1) DEFAULT' || 'N' || 'NOT NULL)');
>
> > > i got an error ORA-00907: missing right parenthesis.
>
> > > whe can be the mistake?
>
> > If you remove the superfluous concatenations of string constants you'll
> > immediately see it. :-)
>
> > Kind regards
>
> >         robert
>
> > --
> > remember.guy do |as, often| as.you_can - without endhttp://blog.rubybestpractices.com/- Hide quoted text -
>
> - Show quoted text -

DEFAULTNNOT is not an oracle reserved word ... Received on Mon Jun 21 2010 - 14:14:37 CDT