Hello all,
The task is to insert the following data into a varchar2 column:
create table a (aa number, ab number, ac varchar2(2000));
insert into a values(135, 2212, 'where auto = 'F'');
Obviously, the following error occurs:
SQL Error: ORA-00917: missing comma
I tried this:
insert into a values(135, 2212, 'where auto = q'['F']'');
and it didn't work:
SQL Error: ORA-00917: missing comma
and I tried this:
insert into a values(135, 2212, 'where auto = q''F''');
but the result was wrong:
select * from a;
135 2212 where auto = q'F'
Could you please help with this insert?
Thank you.