Hi,
I am working on a 12c database.
I am trying to crearte a table with COLLATE BINARY_CI feature on a column, like:
create table t1 (
id number,
company varchar2(15 char) COLLATE BINARY_CI,
constraint t1_pk primary key (id)
);
But I get the following error:
SQL> create table t1 (
id number,
company varchar2(15 char) COLLATE BINARY_CI,
constraint t1_pk primary key (id)
); 2 3 4 5
company varchar2(15 char) COLLATE BINARY_CI,
*
ERROR at line 3:
ORA-00907: missing right parenthesis
Does someone know what the correct syntax is?
Kind Regards