i am using autocomplete with oracle Db,how to create unique keyword for the table.
KEYWORD VARCHAR2(100) COUNT 开发者_StackOverflow中文版 NUMBER(18)
how can i make as unique
can plz tell the query
ALTER TABLE mytable add CONSTRAINT keyword_unique UNIQUE (keyword);
create table "unique keyword" ("KEYWORD" VARCHAR2(100), "COUNT" NUMBER(18));
I think that will do the trick ;-)
精彩评论