Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
select to_char(1890.55, ‘$0G000D00’) from dual; — 1,890.55
select to_char(1890.55, ‘$9,999V99’) from dual; — 1,89055
–Returns a value multiplied by 10n (and if necessary, round it up), where n is the number of 9’s after the V.
select to_char(1890.55, ‘99,999D99’) from dual; — invalid number format
select to_char(1890.55, ‘$99G999D00’) from dual; –1890.55
select to_char(1890.55, ‘$99G999D99’) from dual; –1890.55
— other points to note.
–Presence of ‘$’ symbol has no difference in outcome.
–Conclusion 999 format will work only with G & D. You cannot use G and ‘.’, or D and ‘,’.
select to_char(12345.01, ‘999G999.99’) from dual; –invalid
select to_char(12345.01, ‘999G999D99’) from dual; –12,345.01
select to_char(12345.01, ‘999,999D99’) from dual; –invalid
select to_char(12345.01, ‘999,999.99’) from dual; –12,345.01
select to_char(12345.01, ‘999G999.99’) from dual; –invalid
A,D,E
A, D, E
Why not C ? and Why A ?
Hi! Can someone send me please the latest dumps please? In the real exam there is only about 15 of these question. I went through this like 10 times, learned all the explanations, but got 56% (needed 65%). Please, someone help?
My email address – [email protected]