Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> another & question

another & question

From: Dan Johnson <daniel.johnson.1_at_wcom.com>
Date: Fri, 08 Dec 2000 15:41:40 -0600
Message-Id: <10704.124115@fatcity.com> 





what if the data contains an ampersand '&'
in sqlplus


select * from weekend


where timeoff = 'Saturday & Sunday'


you get


Enter value for Sunday



in sqlplus i can set define to another character but how to handle this in
an application? should the application alter its session as well?



thanks and tgif



Dan Johnson
Received on Fri Dec 08 2000 - 15:41:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US