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-12491: DBHIGH value does not dominate DBLOW

1 Answers  


ORA-12995: no columns in partially dropped state

1 Answers  


ORA-31632: master table "string.string" not found, invalid, or inaccessible

1 Answers  


PCC-00126: Could not find or open system configuration file

1 Answers  


ORA-32815: message system link string is referenced by a foreign queue

1 Answers  


ORA-02204: ALTER, INDEX and EXECUTE not allowed for views

1 Answers  


ORA-08437: invalid picture type in picture mask

1 Answers  


ORA-13275: spatial index creation failure on unsupported type

1 Answers  


RMAN-06716: skipping datafile number; already restored to file string

1 Answers  


ORA-01522: file 'string' to be renamed does not exist

1 Answers  


NZE-29033: Invalid PFX

1 Answers  


ORA-23428: job associated instance number string is not valid

1 Answers  


Categories