Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29346: invalid tablespace list

1 Answers  


ORA-19508: failed to delete file "string"

1 Answers  


ORA-25467: table alias not specified

1 Answers  


ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


DRG-10313: logging has already been started

1 Answers  






SQL*Loader-00949: incorrect datafile string specified for table string subpartition string

1 Answers  


RMAN-06461: Current controlfile cannot be backed up by proxy.

1 Answers  


KUP-04023: field start is after end of record

1 Answers  


ORA-01304: subordinate process error. Check alert and trace logs

1 Answers  


ORA-24142: invalid ruleset name

1 Answers  


TNS-01101: Could not find service name string

1 Answers  


ORA-14043: only one partition may be added

1 Answers  






Categories