OraFAQ Forum: Client Tools » Insert statement.

Home » Other » Client Tools » Insert statement.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert statement. [message #254523]

Fri, 27 July 2007 01:00

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

Report message to a moderator

Re: Insert statement. [message #254533 is a reply to message #254523]

Fri, 27 July 2007 01:18

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

Report message to a moderator

Re: Insert statement. [message #254655 is a reply to message #254533]

Fri, 27 July 2007 06:42

arj007
Messages: 6
Registered: July 2007
Location: Bangalore

Junior Member

thank you.

Report message to a moderator

Previous Topic:	about sql editor.
Next Topic:	procedure error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 16:19:55 CST 2024