Sql insert '

quinnd6

I want to insert a name into a table which has a apostrophe but am having problems doing this with sql plus.

I got this error

ERROR at line 1:
column not allowed here

Any ideas?

FindingNemo

quinnd6 wrote: »

I want to insert a name into a table which has a semi-colon but am having problems doing this with sql plus.

I got this error

ERROR at line 1:
column not allowed here

Any ideas?

can you post your insert statement up pls ?

quinnd6

insert into table(fielda,fieldb,fieldc,date) values ("JO'SMITH","J.O'SMITH@SMITHS.ie",333, to_date('30/10/07','dd/mm/yy') );

I also tried this beforehand
insert into table(fielda,fieldb,fieldc,date) values ('JO'Smith' ,'J.O'Smyth.ie',333, to_date('31/01/07','dd/mm/yy') );

and got string not properly terminated

FindingNemo

quinnd6 wrote: »

insert into table(fielda,fieldb,fieldc,date) values ("JO'SMITH","J.O'SMITH@SMITHS.ie",333, to_date('30/10/07','dd/mm/yy') );

I also tried this beforehand
insert into table(fielda,fieldb,fieldc,date) values ('JO'Smith' ,'J.O'Smyth.ie',333, to_date('31/01/07','dd/mm/yy') );

and got string not properly terminated

try this


insert into table(fielda,fieldb,fieldc,date) values ('JO''Smith' ,'J.O'Smyth.ie',333, to_date('31/01/07','dd/mm/yy') );

FindingNemo

FindingNemo wrote: »

try this


insert into table(fielda,fieldb,fieldc,date) values ('JO''Smith' ,'J.O'Smyth.ie',333, to_date('31/01/07','dd/mm/yy') );

sorry, just did the first column for you, this is correct.

insert into table(fielda,fieldb,fieldc,date) values ('JO''Smith' ,'J.O''Smyth.ie',333, to_date('31/01/07','dd/mm/yy') );[/QUOTE]

Tom Dunne

Or try Google - insert apostrophe oracle

Giblet

Are you typing this straight into the database, or through a driver for java etc.
You could use prepared statements if you're using oracle + java.