Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 into when you include a literal ampersand value or both a literal ampersand value and a substitution variable in your script followed by a couple of workarounds Code Listing 9 When you want a literal text ampersand returned in your result SQL select This That 2 from dual Enter value for that old 1 select This That new 1 select This ORACLE MAGAZINE JULY AUGUST 2017 114 THIS This Create a database script called handle_ the_ ampersand sql set define off select This That from dual Execute the script SQL @ handle_ the_ ampersand sql THIS THAT This That
You must have JavaScript enabled to view digital editions.