Home » SQL & PL/SQL » Client Tools » inserting a data with substitutuion variable (Oracle 11g 11.2.0.1.0)
inserting a data with substitutuion variable [message #555496] Thu, 24 May 2012 11:36 Go to next message
sss111ind
Messages: 579
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

Report message to a moderator

Re: inserting a data with substitutuion variable [message #555497 is a reply to message #555496] Thu, 24 May 2012 11:38 Go to previous messageGo to next message
BlackSwan
Messages: 25797
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/
Re: inserting a data with substitutuion variable [message #555632 is a reply to message #555497] Fri, 25 May 2012 11:34 Go to previous messageGo to next message
sss111ind
Messages: 579
Registered: April 2012
Location: India
Senior Member


Thanks BlackSwan.
Re: inserting a data with substitutuion variable [message #555966 is a reply to message #555632] Wed, 30 May 2012 04:54 Go to previous message
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: Sat Jan 20 05:59:19 CST 2018

Total time taken to generate the page: 0.01043 seconds