There is a delete script as follow:Delete Form
where Type_code = UPPER('&&type_code')This script will be ran in Unix environment, and the problem is:If I enter a value which contains an SPACE, it would not be identified. e.g: C ODE (There is a space between 'C' and 'O')How should I fix that in this script?Thanks in advance.I'm sorry I can't type Chinese here.
where Type_code = UPPER('&&type_code')This script will be ran in Unix environment, and the problem is:If I enter a value which contains an SPACE, it would not be identified. e.g: C ODE (There is a space between 'C' and 'O')How should I fix that in this script?Thanks in advance.I'm sorry I can't type Chinese here.
SELECT '&&KL' FROM DUAL;Note: the column title value