Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL PROBLEM with &
Hi,
Try
insert into tname values (1000,'test'||'&'||'01');
Regards,
Balaji.
"George D. Benetos" <gbenet_at_intranet.gr> wrote in message news:a8c02c$b8e$1_at_newsserv.intranet.gr...
I AM TRYING TO insert a string with & in PLSQL and i get the message for
enter value
How can insert the string 'test&01' in database ??
insert into adm_trace_log(TRACENO,LOGMESSAGE) values(100000,'test&01'); Enter value for 01:
thanx ....
--
George D. Benetos
Electrical & Computer Engineer N.T.U.A