Re: query
From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Mon, 21 Jun 2010 21:36:21 +0200
Message-ID: <4c1fbf34$0$10989$e4fe514c_at_dreader20.news.xs4all.nl>
stunaz 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
>>
Date: Mon, 21 Jun 2010 21:36:21 +0200
Message-ID: <4c1fbf34$0$10989$e4fe514c_at_dreader20.news.xs4all.nl>
stunaz 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
>>
Change the last part of your code to:
<...> ADD (SEND_ITEM VARCHAR2(1) DEFAULT 'N' NOT NULL)');
HTH.
-- JeroenReceived on Mon Jun 21 2010 - 14:36:21 CDT