Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 Mix substitution variables with literal text ampersands Create a database script called variables_ and_ ampersands sql set define on ORACLE MAGAZINE JULY AUGUST 2017 115 select This That from v_ table Execute the script SQL @ variables_ and_ ampersands sql Enter value for v_ table dual old 2 from v_ table new 2 from dual THIS This That The first line of the database script handle_ the_ ampersand sql is set define off This is a SQL Plus command for disabling the prompting and replacement of substitution variables within the SQL Plus execution environment When this command is issued ampersands are treated as literal values However there might be instances when you want to use both substitution variables and literal amper
You must have JavaScript enabled to view digital editions.