Re: query
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 21 Jun 2010 18:46:56 +0200
Message-ID: <889jc8F90aU2_at_mid.individual.net>
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?
Date: Mon, 21 Jun 2010 18:46:56 +0200
Message-ID: <889jc8F90aU2_at_mid.individual.net>
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 end http://blog.rubybestpractices.com/Received on Mon Jun 21 2010 - 11:46:56 CDT