Home » SQL & PL/SQL » Client Tools » Insert statement.
Insert statement. [message #254523] Fri, 27 July 2007 01:00 Go to next message
arj007
Messages: 6
Registered: July 2007
Location: Bangalore
Junior Member

Hi Friends,
I need to insert the following:

<img src="https://ad.trafficgate.net/e/wfon.pl?m=463&s=1/1/0&oid=cfj" width="1" height="1"><IMG SRC="https://s01.j-a-net.jp/gateway/action.cgi?t=10020&u=cfj"width=1 height=1><IMG SRC="https://is.accesstrade.net/cgi-bin/isat/eloan/isatWeasel.cgi?verify=cfj" width=1 height=1>

into a column which is of type varchar2.

Since the above data has "&" while inserting it acts as a substitution variable but I dont want to substitute anything . Tell me a way to insert the data as such.

Regards
Arjun
Re: Insert statement. [message #254533 is a reply to message #254523] Fri, 27 July 2007 01:18 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi

set define off

like this
SQL> set define off
SQL> insert into depts values(5,'a&');

1 row created.

SQL> select * from depts;

   DEPT_NO D_NAME
---------- --------------------
         1 production
         2 finance
         3 hr
         4 delivery
         5 a&


regards
shanth
Re: Insert statement. [message #254655 is a reply to message #254533] Fri, 27 July 2007 06:42 Go to previous message
arj007
Messages: 6
Registered: July 2007
Location: Bangalore
Junior Member

thank you.
Previous Topic: about sql editor.
Next Topic: procedure error
Goto Forum:
  


Current Time: Sun Dec 04 19:09:18 CST 2016

Total time taken to generate the page: 0.09309 seconds