When running Query and query and output the following error pops up:
-972: ORA-00972: identifier is too long
The error comes up if a column name is too long. An Oracle field in a table should not be longer than 30 characters and should not contain any spaces. If you get this error while running Query and Output, review the Output fields and make sure that they are 30 characters or less, and make sure there are no spaces in the names.