-----Original Message-----
From: Regis Biassala [mailto:Regis.[Email Address Removed] Monday, September 30, 2002 5:40 PM
To: LazyDBA.com Discussion
Subject: RE: SELECT statement doesn't like "&"
One more thing, you'll need to concatenate...
Here an example:
1* insert into a values ('A '||CHR(38)||' B')
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from a;
V
----------
A & B
Regis
-----Original Message-----
From: Heather James [mailto:H.[Email Address Removed] Monday, September 30, 2002 4:25 PM
To: LazyDBA.com Discussion
Subject: Re: SELECT statement doesn't like "&"
Hello Gurus
I have a series of select statements in one script which I am using to check
data in two fields prior to running an update script.
However, when I run the select script if there is an "&" in the string then
it stops and asks me for the value of customer_name. If I hit return it
prints out the same company_name but misses out the "&" + the next part of
the string. If there is anything beyond "&" + the next part of the string
it is kept in the field .
e.g.
SELECT rep_id, customer_name FROM schema.customer_table WHERE customer_id =
'111155' AND customer_name = 'AAA BBB & Fixings Company Ltd';
UPDATE customer_table SET rep_id = 'LS.' WHERE schema,customer_id =
'111155' AND customer_name = 'AAA BBB & Fixings Company Ltd';
What happens when running the select scripts in SQL*PLUS:
Enter value for fixings:
old 1: SELECT rep_id, customer_name FROM schema.customer_table WHERE
customer_id = '111155' AND customer_name = 'AAA BBB & Fixings Company Ltd'
new 1: SELECT rep_id, customer_name FROM schema.customer_table WHERE
customer_id = '111155' AND customer_name = 'AAA BBB Company Ltd'
The script carries on okay until it hits a similar problem.
Can someone enlighten me about this and give some clues that I can follow to
solve the problem?.
Thank you.
Rgds,
Heather James
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
Operating system: Windows 2000
This e-mail and any attached files are for the explicit use of the addressee
ONLY.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution
or any other dissemination or use of this communication is prohibited. If
you have received
this communication in error, please would you notify the sender either via
e-mail
or by telephoning 0117 9086500 and immediately delete this file.
E-mail transmission cannot be guaranteed to be secure or error free, as
information can be
intercepted, corrupted, lost, destroyed, arrive late or be incomplete, or
contain viruses. The sender
does not accept any liability for any error, omission or corruption which
arises from this e-mail
transmission.
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page