Running the same script in version 12.5 generates the error, ORA-00928: missing SELECT keyword
select chr(10) || ' Host_Name: ' || host_name from v$instance
union all
select ' DB_Instance: ' || rpad(name,10) || 'DBID: ' || dbid
from v$database
union all
union all
select ' Oracle_Version: ' || version || chr(10) || chr(10) from v$instance
*
Error at line 6
ORA-00928: missing SELECT keyword
This script ran properly in version 11.5 and 11.6
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center