Tag Archives: ORA-01728

ORA-01728: numeric scale specifier is out of range (-84 to 127)

oracle

ORA-01728: numeric scale specifier is out of range (-84 to 127)
Cause: The scale specified for a numeric field in a CREATE/ALTER TABLE or CREATE CLUSTER statement is not in the valid range. It should be between -84 and 127.
Action: Specify a numeric scale between -84 and 127. If a number is not specified, the default scale of the column is 0 decimal places.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/