Originally posted by edsperez
How do I insert a row in a table with comma using SQLPlus?
ex.

insert into mytable(description)
values('Spoon,Fork');

normally this will give ORA-01756: quoted string not properly terminated.
You must have mixed something up. You won't get ORA-1756 when your string contains comma - but you'll get this error if your string contains a single quote, like in

insert into mytable(description)
values('Spoon 'n Fork');

in such a case you have to replace single quote with two single quotes, like in:

insert into mytable(description)
values('Spoon ''n Fork');