+ 1
what is use of pr and mi format model in to_char function in oracle database
Oracle Database 11g SQL
1 Réponse
+ 1
PR; Returns negative value in <angle brackets>.
Returns positive value with a leading and trailing blank.
Restriction: The PR format element can appear only in the last position of a number format model.
MI; Returns negative value with a trailing minus sign (-).
Returns positive value with a trailing blank.
Restriction: The MI format element can appear only in the last position of a number format model.