how to create unique keyword in the oracle db?

Question

hi,

i am using autocomplete with oracle Db,how to create unique keyword for the table.

KEYWORD VARCHAR2(100) COUNT NUMBER(18)

how can i make as unique

can plz tell the query

Answer 1

ALTER TABLE mytable add CONSTRAINT keyword_unique UNIQUE (keyword);

Answer 2

create table "unique keyword" ("KEYWORD" VARCHAR2(100), "COUNT" NUMBER(18));

I think that will do the trick ;-)