Answer / guest

Cause: An illegal query was specified. Specifically one of
the following criteria was not satisfied: (a) All
(non-constant, non-aggregate) SELECT expressions in the
query should be made up of group expressions. (b) All column
references in the HAVING clause should come from the GROUP
BY expressions. (c) If there is an ORDER BY clause, then all
column references should come from the GROUP BY or SELECT
clause, depending on whether the query selects DISTINCT.

Action: Correct error in the syntax and rerun the query.

Please add more information about this Error

NNL-00508: show system_queries [<server_list>] : show system query information

1 Answers  

---

ORA-27471: window "string.string" is already closed

1 Answers  

---

NNL-00279: Restart occurs in string

1 Answers  

---

ORA-24759: invalid transaction start flags

1 Answers  

---

ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

1 Answers  

---

CLSR-00520: No service member found

1 Answers  

---

ORA-38459: XML Tag "string" not found for the XMLType attribute "string"

1 Answers  

---

TNS-01022: Alias string

1 Answers  

---

PCC-00089: Invalid Oracle TYPE specification

1 Answers  

---

ORA-01579: write error occurred during recovery

1 Answers  

---

ORA-13637: Executing or modifying task string is disallowed until the task is reset to its initial state.

1 Answers  

---

IMG-00715: unable to open image stored in a BFILE

1 Answers  

---