query
in [Oracle]
|
From: stunaz on 21 Jun 2010 10:44 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? thank you
From: Robert Klemme on 21 Jun 2010 12:46 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/
From: stunaz on 21 Jun 2010 13:16 cant still see it On 21 juin, 12:46, Robert Klemme <shortcut...(a)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/
From: magicwand on 21 Jun 2010 15:14 On Jun 21, 7:16 pm, stunaz <stu...(a)gmail.com> wrote: > cant still see it > On 21 juin, 12:46, Robert Klemme <shortcut...(a)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 ...
From: The Boss on 21 Jun 2010 15:36
stunaz wrote: > cant still see it > On 21 juin, 12:46, Robert Klemme <shortcut...(a)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. -- Jeroen |