Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What's the difference between DEFAULT ' ' and DEFAULT (' ')?

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

From: Andy <enzoweb_at_hotmail.com>
Date: 4 Jun 2002 18:03:24 -0700
Message-ID: <8d4033cd.0206041703.601bffc3@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:03:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US