what is use of pr and mi format model in to_char function in oracle database | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

what is use of pr and mi format model in to_char function in oracle database

Oracle Database 11g SQL

23rd Jul 2016, 4:35 PM
Saurabh Joshi
Saurabh Joshi - avatar
1 Answer
+ 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.
17th Apr 2017, 5:17 AM
‎‏‪4CORNERS “WALLIE”‬‏‎
‎‏‪4CORNERS “WALLIE”‬‏‎ - avatar