I had a query that I was trying to run - update work_order_control set description = 'Cust Sv-C&I-Upgrade- VA' where work_order_number = 'BAP0000024';
When running this query in TOAD (or sql plus, or sql-station, probably most others) I run into this issue where the tool or Oracle thinks the symbol after the & is a variable and asks for a value for that variable. What I wanted to know was is there an "override" character that is used to allow this to run without thinking there is a variable due to the & symbol instead of using it as the intended literal.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center