Home » SQL & PL/SQL » SQL & PL/SQL » SQL Plus Worksheet/insert/special Characters
SQL Plus Worksheet/insert/special Characters [message #2387] Wed, 10 July 2002 12:34 Go to next message
KSRA
Messages: 1
Registered: July 2002
Junior Member
Does anyone know how to do an insert into Oracle SQL Plus Worksheet when a value has an & in it? Evidently, SQL Plus Worksheet sess the & as a continuation character.

example: insert into jobcodes(jobcode, jobtitle) values('A070', 'Research & Development Specialist')

Thanks.

Report message to a moderator

Re: SQL Plus Worksheet/insert/special Characters [message #2389 is a reply to message #2387] Wed, 10 July 2002 12:42 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
set scan off

Report message to a moderator

Previous Topic: sql question
Next Topic: ADO 'inner join' SQL statement to Oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:02:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.