Re: change data_default

On Fri, 8 Aug 2003 11:46:11 +0200, "Hubert Holler" <haiflosse_at_gmx.net> wrote:

>Can somebody tell me how I can change the data_default of a filed.
>my table is called "media" and the filed is called "med_activ" and the
>default value should be "1".
>
>Hope somebody can help me there.
>Thanks a lot
>Hubert
>

Just use the alter table modify command. NEVER EVER try to update the dictionary directly

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 08 2003 - 10:10:44 CDT