UPPER function ..........ORA-00921: unexpected end of SQL command
Hi
getting below error.
SQL> @c:\test_user.sql;
Enter value for username: mapple
old 1: DROP USER UPPER(&&USERNAME) CAS
new 1: DROP USER UPPER(mapple) CASCADE
DROP USER UPPER(mapple) CASCADE
*
ERROR at line 1:
ORA-00921: unexpected end of SQL command
want to convert the user input into uppercase.
cant we use UPPER() function over here ?
how it can be done ?
With Regards