PLS-00670: sort columns must be simple column names



PLS-00670: sort columns must be simple column names..

Answer / guest

Cause: An attempt was made to specify an expression as a
sort column in a PARTITION BY, CLUSTER BY or ORDER BY
clause. Only simple column names are permitted.

Action: Specify a simple column name.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12040: master rollback segment option not support by master site string

1 Answers  


ORA-25238: too many recipients specified for message destination string

1 Answers  


DRG-12233: xml sections cannot co-exist with other section types

1 Answers  


ORA-16112: log mining and apply stopping

1 Answers  


ORA-39312: illegal clean_target() call: last clone operation is failed

1 Answers  


LPX-00249: invalid external ID declaration

1 Answers  


ORA-12634: Memory allocation failed

1 Answers  


ORA-28579: network error during callback from external procedure agent

1 Answers  


ORA-01544: cannot drop system rollback segment

1 Answers  


TNS-01062: The db subagent is already running.

1 Answers  


ORA-39954: DEFERRED is required for this system parameter

1 Answers  


PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  


Categories