Re: What's the difference between DEFAULT ' ' and DEFAULT (' ')?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 5 Jun 2002 11:35:06 +1000
Message-ID: <W%dL8.5310$Hj3.16689@newsfeeds.bigpond.com>

Hi Andy,

Both should work if the number of parenthesis are correct.

In the examples you've provide, both should give you errors because of incorrect number of parenthesis. The first example should work if either you get rid of the first parenthesis or add a parenthesis at the end.

Richard
"Andy" <enzoweb_at_hotmail.com> wrote in message news:8d4033cd.0206041703.601bffc3_at_posting.google.com...
> I added a column for a user with
>
> alter table foo add(bar varchar2(10) default ' ';
>
> and the application rejected it, until I changed it with
>
> alter table foo modify(bar varchar2(10) default (' ');
>
> Isn't this the same thing?
>
>
> V806 on Solaris 2.7.
Received on Tue Jun 04 2002 - 20:35:06 CDT