Re: this insert is not working .....

It's not advisable to use implicit naming of columns in SQL statements. You should better use your INSERT statement specifying exact names of columns:

insert into cccb(cccb_id, com_name) values(200 ,'Advisory C');

user wrote:
> com_name varchar2(50) NOT NULL,
> CONSTRAINT cccb_pk PRIMARY KEY (cccb_id));
>
> insert into cccb values (150 ,'Annexation C');
> insert into cccb values(200 ,'Advisory C');
> insert into cccb values(800 ,'Protection C');
> insert into cccb values(1000 ,'Transit C');
> insert into cccb values(1050 ,'Water C');
>
> insert errors out with
>
> ORA-00911: invalid character
>
> any suggestions?
Received on Mon Nov 20 2006 - 09:11:34 CST