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-16592: missing field "string" in document

1 Answers  


ORA-39957: invalid warning category

1 Answers  


ORA-01184: logfile group string already exists

1 Answers  


NNL-00240: Starting "string"...

1 Answers  


ORA-13128: current tiling level exceeds user specified tiling level

1 Answers  






TNS-00221: Pump Connections Total Data Bytes/Second

1 Answers  


ORA-02026: missing LINK keyword

1 Answers  


DRG-11816: Use Proxy

1 Answers  


ORA-32502: Cannot execute command. Flash Freeze is not in effect

1 Answers  


ORA-22918: specified column or attribute is not a VARRAY type

1 Answers  


ORA-22063: reading negative value [string] as unsigned

1 Answers  


ORA-22317: typecode number is not legal as a number type

1 Answers  


Categories