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

PROC-00016: Cannot retrieve any more subkeys for the given keyhandle

1 Answers  


ORA-00402: database changes by release string cannot be used by release string

1 Answers  


DRG-11715: attempt to add a BT relation between 2 KB categories string and string

1 Answers  


ORA-24199: message store is overflow

1 Answers  


SQL*Loader-00802: numeric EXTERNAL with DEFAULTIF clause not supported by External Table

1 Answers  


ORA-01184: logfile group string already exists

1 Answers  


RMAN-06197: Total System Global Area string bytes

1 Answers  


ORA-30088: datetime/interval precision is out of range

1 Answers  


ORA-13483: insufficient memory for the specified GeoRaster data

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  


PLS-00491: numeric literal required

1 Answers  


NNL-00294: No entries found

1 Answers  


Categories