+ 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 Odpowiedź
+ 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