Oracle
1Z0-061 · Question #265
Which SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)
The correct answer is A. SELECT TO_CHAR(1890.55, '$0G000D00') D. SELECT TO_CHAR(1890.55, '$99G999D00') E. SELECT TO_CHAR(1890.55, '$99G999D99'). See the full explanation below for the reasoning.
Question
Which SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)
Options
- ASELECT TO_CHAR(1890.55, '$0G000D00')
- BSELECT TO_CHAR(1890.55, '$9, 999V99')
- CSELECT TO_CHAR(1890.55, '$99, 999D99')
- DSELECT TO_CHAR(1890.55, '$99G999D00')
- ESELECT TO_CHAR(1890.55, '$99G999D99')
How the community answered
(40 responses)- A73% (29)
- B10% (4)
- C18% (7)
Community Discussion
No community discussion yet for this question.