Does anyone know if you could concatenate a sqlplus variable to a literal like
define tab=test
rename &tab to &tab123
this doesnt work
cheers
Printable View
Does anyone know if you could concatenate a sqlplus variable to a literal like
define tab=test
rename &tab to &tab123
this doesnt work
cheers
Code:SQL> define tab=xyz
SQL> rename &tab to &tab.123
2 ;
old 1: rename &tab to &tab.123
new 1: rename xyz to xyz123
Table renamed.
cheers