Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: this insert is not working .....

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

From: Kaushik <kaushiknfs_at_gmail.com>
Date: 19 Nov 2006 23:02:18 -0800
Message-ID: <1164006138.692680.243700@f16g2000cwb.googlegroups.com>


whats the table structure of cccb?

On Nov 20, 10:10 am, user <some..._at_someplace.org> 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 - 01:02:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US