OraFAQ Forum: Client Tools » inserting a data with substitutuion variable

Home » Other » Client Tools » inserting a data with substitutuion variable (Oracle 11g 11.2.0.1.0)

Thu, 24 May 2012 11:36

sss111ind
Messages: 629
Registered: April 2012
Location: India

Senior Member

Hi All,

I want to insert the value with '&'. But this is treated as substitution variable by oracle.So how can it is possible to do like this

INSERT INTO DEPT (DEPTNO, LOC, DNAME)
     VALUES (50, '&NEW YORK', 'SALES');

Regards,
Nathan

[EDITED by LF: fixed [code] tags]

[Updated on: Thu, 24 May 2012 14:44] by Moderator

Thu, 24 May 2012 11:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SET DEFINE OFF

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Fri, 25 May 2012 11:34

sss111ind
Messages: 629
Registered: April 2012
Location: India

Senior Member

Thanks BlackSwan.

Wed, 30 May 2012 04:54

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

One more option..

SET SCAN OFF;

Previous Topic:	temperature symbol required
Next Topic:	import of data from Excel file into table

Goto Forum:

]

Current Time: Tue Oct 03 16:26:08 CDT 2023