I plan to use query "SELECT STATUS from V$INSTANCE" to get database status. Expected results are "STARTED", "MOUNTED" and "OPEN".
The Monitoring tool I use expects a single digit status.
Can anyone suggest a method of converting the returned STATUS into a single digit.
Thanks in advance.