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 -> Re: Howto do undo a default clause?

Re: Howto do undo a default clause?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Fri, 01 Aug 2003 02:23:47 +0100
Message-ID: <n7gjivgghdkgrjfvf36siumhvrjhvcgkhg@4ax.com>


On 31 Jul 2003 18:16:02 -0700, wizofoz2k_at_yahoo.com.au (Nuno Souto) wrote:

>create table zot(
>f1 number default 0,
>f2 date);
>.
>Now, I want to remove the "DEFAULT 0"
>from the table.
>.
>alter table zot modify(f1 ......<wth?>);

alter table zot modify (

    f1 DEFAULT NULL
);

-- 
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Received on Thu Jul 31 2003 - 20:23:47 CDT

Original text of this message

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