Re: sql startment problem PLEASE HELP .....

Поиск
Список
Период
Сортировка
От Stephen Bell
Тема Re: sql startment problem PLEASE HELP .....
Дата
Msg-id 3B43591F.5AEEBDB5@cgi.ca
обсуждение исходный текст
Ответ на sql startment problem PLEASE HELP .....  (boy_66@hotmail.com (penny))
Список pgsql-sql
Hi Penny,

I hope someone proves me wrong, but I don't think you can modify a
constraint like that....I believe you have to drop it and recreate it.

Steve

penny wrote:

> Hi all,
>
> I am using Oracle8i Enterprise Edition in window 2000
>
> my problem as following
>
> ~~~~~~~~~~~~~~~~~~~~~
>
> SQL>  create table ttt
>   2   ( name varchar2(100)
>   3   ,
>   4   constraint e check (name = lower(name)));
>
> Table created.
>
> SQL> alter table ttt
>   2  modify constraint e
>   3  check (name = upper(name));
> check (name = upper(name))
> *
> ERROR at line 3:
> ORA-00933: SQL command not properly ended
>
>
> How can I modify constraint e ????
>
>                                   thanks.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Ken Corey
Дата:
Сообщение: Re: Re: Using Random Sequence as Key
Следующее
От: msalt@uol.com.br (Txugo)
Дата:
Сообщение: SQL - histogram