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-12545: Connect failed because target host or object does not exist

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  


AMD-00144: Custom Measure "string" does not exist in Workspace "string"

1 Answers  


ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 Answers  






DRG-51017: unable to open storage buffer for fuzzy match candidates

1 Answers  


ORA-01776: cannot modify more than one base table through a join view

1 Answers  


PLS-01474: Use of ANY is non_ANSI

1 Answers  


ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.

1 Answers  


TNS-00073: * stop/abort - stop the process_name

1 Answers  


ORA-25143: default storage clause is not compatible with allocation policy

1 Answers  


ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 Answers  


Categories