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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL PROBLEM with &

Re: PLSQL PROBLEM with &

From: Balaji j <balaji_n29_at_hotmail.com>
Date: Tue, 2 Apr 2002 17:01:55 +0530
Message-ID: <a8c4pe$5h0$1@news.mch.sbs.de>


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


Received on Tue Apr 02 2002 - 05:31:55 CST

Original text of this message

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