I'm trying to add a condition to the emcli list -sql command.
emcli list -sql='select TARGET_NAME,DISPLAY_NAME,HOST_NAME from mgmt$target'
Works great.
emcli list -sql='select TARGET_NAME,DISPLAY_NAME,HOST_NAME from mgmt$target WHERE TARGET_TYPE="oracle_database"'
Invalid column name : Error is ORA-00904: "ORACLE_DATABASE": invalid identifier
Are WHERE clauses not allowed? No matter how I attempt to dereference this I get the same result. Invalid column name.